ACCESS 2 SQL

[newmedia]

Currently have a web site that uses Access database files how hard would it be to convert them to a SQL server and will my calls in my asp pages change considerably.

Your help in this matter is much appreciated.

Steve

[Ruttiger]

what ya wanna do is, disable any changes to the server. keep it down for a little bit, just to make sure all the activity is done. however, if you can/want to, users can still read from it.

You're goin to want to create a script that dumps the SQL into an "in-between" format. you wanna make sure that the delimiters cannot appear in the fields...for instance, you can't tab-separate the fields if the user can enter a tab in one of the fields...that wouldn't work :)
one of my favorites quickies is to separate columns by \1 and to separate rows by \2.
that should work.

anyway, then you're goin to want to have another script that reads in that file you just created, and enters it all back in the new database.

As for the differences in the SQLs? I haven't used Access before, but SQL is it's own language. The only real changes will come in the field types, and stuff like that. You'll probably have types available in Access that aren't in SQL, and vice-versa. So, you're goin to want to find the next-best one. The actual queries shouldn't really change much if at all.

Side note for ya, AFAIK, Access and ASP are only for Microsoft Servers. Do you have SQL already on this machine, or are you switching to a Linux box? In the first case, you should know that SQL is only free for Linux-based systems, and for the second case, you should know (if i'm right) that ASP is for Microsoft-only servers.

so, don't rush into this conversion. it'll probably work out fine, but you want to put a lot of research and planning into it.
make sure to test the new database heavily!

lemme know if this helps,
Blake

[Podge]

Is there a solution for converting multiple Access databases to Sql Server?

[whkoh]

This article might help you:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=6133

[Podge]

Hi, thanks for the response.

Afraid it doesn't help. I am aware of the upsizing wizard, dts, etc. but I cannot use them.

There are about 3,000 databases. Any of the above methods would require me to do it manually.