Conversions

I know that if you are using SQL Enterprise Server, you could do an import from Access that will import all your tables and data.  You can also export it back into Access as well.

There is also something called an Access Upsize Wizard that people keep talking about.  Since I started with SQL, I never had to use it.  Apparently it helps you convert from Access to SQL.

Edited by wistex

It will be worth it due to the performance and scalability.

I was searching through this forum and there is a Access Upsize Wizard that converts to SQL.  You would use that for your conversion.

There are a lot of areas where you could mess up.  I suggest doing a search on it to see the various discussions.  And making sure you do a back-up before you do anything.

Trying to upgrade the database from access to SQL is a hit and miss affair, I have read here that several people have managed it succesfully but having tried it several times myself I have been unable to do an error free upgrade.

Without doubt the SQL version is the way to go though.

First thing you have to do is make a blank database on the SQL server using the script that comes with the SQL version forum, this ensures you are using the stored procedures with the SQL version.

Then you have to use the upsize wizard to import the data from the access DB. I don't recall right now, but there are a couple of other steps involved when importing the data, you'll have to look for the post its explained in elswhere on the forum here.