How can I convert a program currently using an Access database to use Microsoft SQL Server?

Question

I have a Windows application written in C# that works with an Access database file. Furthermore, I use some DataSets in my project that work with this Access database.

Arising from this, I have two questions:

1. How can I convert the Access database file into an SQL Server database, and
2. How can I convert the project code (using Access DataSets) to work with the SQL Server database?

Answer 1

I believe that MS-Access has an "export to SQL" functionality somewhere. simple google reveals details here and here

Answer 2

Have you tried using the inbuilt upsizing wizard in MS Access? Under Access 2007 its under the Database Tools tab | SQL Server.

From the description: "The Upsizing wizard allows you to easily upsize your Microsoft Access Database to a Microsoft SQL server database"

Answer 3

Try SQL Server Migration Assistant for Access from the link below.

http://www.microsoft.com/downloads/details.aspx?FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&displaylang=en

and for SQL Server Migration Assistant 2008 for Access

http://www.microsoft.com/downloads/details.aspx?FamilyID=133b59c2-c89c-4641-bebb-6d04476ec1ba&DisplayLang=en

Answer 4

you can import database from access db to sql server. for this you can make a new db in sql server, then press right click in db name, after that from showed menu, go like below:

Tasks->Import Data

use Microsoft Access as data source. this is the best way.