How to convert MS Access Database into SQL Server database?

In this article I have explained about how to convert/Migrate MS Access database (.mdb) into SQL Server Database (.mdf). Large numbers of data are stored in MS Access database is affecting your project speed and also difficult to handle data in MS Access. In that difficult situation we need to migrate MS access database to SQL Server Database with already available data on that existing MS Access tables. This article is help to you for transfer MS Access database to SQL Server database.

My sample Access database looks like below with two tables (emp and dept)

Steps to be followed to convert MS Access Database into SQL Server database:

Step 1 :
Create New Database in the SQL Server


Step 2 :
Select newly created database and right click on that database then choose Tasks --> Import Data


New pop up window is opened then you can select in that pop up window "Microsoft Access" in the data source drop down list and choose file path using browse option.


Then click "Next" Button new screen in opened in that screen select Authentication as "Windows Authentication" If you have SQL Server user authentication then use that option otherwise better to use "Windows Authentication" for local system. Finally check restore database name correct or not last of the same screen.


Then click "Next" Button new screen is opened in that screen Check the option "Copy data from one or more tables or views".


Then click "Next" Button new screen is opened in that screen you can select all tables are convert to that SQL Server database or particular tables want to convert into SQL Server database


Then click "Next" Button new screen is opened in that screen you click the "Run Immediately" check box.


Then finally click "Finish" Button in that pop window, process is executed like below


After complete process your MS Access database convert into SQL Server database like below.


Note: If you don't have Import option then use DTSWizard it's available on the below path.
"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

I hope this article is help you to convert MS Access into SQL Server database.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: