In this article, we will talk about migrating a database in MDB to SQL with of Migration Assistant!
The great advantage of SQL is that you can store the database on a server, allowing everyone connected to that instance to have the same components, pages and settings. The changes will be effective for everyone. Another advantage of SQL is loading the tables faster, being more efficient than the MDB files.
To do the migration, we will have to use the SQL server Migration Assistant for Acess. You can download it clicking here.
You just need to download the version according your computer, like 32 or 64 bits.
After this, download the proper version
After download it, open the directory of the file and run the installer.
Allow the file to make modifications and click finish after the installation is finished.
Open the software. This is the program that we will use to do the migration of the tables in MDB to SQL.
Click next, this window will appear to create a project.
Here, you will inform the name of the migration project. In my case, I will leave the default name. Then, the location of the new SQL database will be saved, and finally, to which SQL server you want to migrate. In my case, I have SQL Server 2014 installed, so I will select it.
In this window, you need to select the MDB database that you want to migrate.
To choose it, click in add database. A window will appear to the user make the bank note. In this case, I will be converting a software base from G-Electrical in MDB into SQL server.
After adding the database, click on next.
A window will appear, you should check the Tables box (to convert the database tables), and after this click on next.
A window to configure the database instance in SQL Server wil appear.
Fill the data required. You can just copy from the SQL Management Studio.
The message below will appear, click “yes” to create the new database.
After that, the assistant window will appear to perform the migration. We can only give next
The assistant will start the convertion of the tables to SQL. After that, you can check the tables correctly converted.
Now you need to charge and migrate the objects to the new database. To do it just click ok in the previus screen. After the migration, you just close the assistant window.
The last procedure to do is to enter in your SQL management studio and verify that the database was created and the converted tables are there.