Few Steps To Move A Database: MS Access to SQL Server Migration

Asked By Head Jonathon 0 points N/A Posted on - 07/08/2016

Hello people,

I want to perform MS Access to SQL Server Migration. I have been trying it but could not do it. Someone out there, please, help me out with this Migration process.

• Status: Open
• Question Views: 403
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Gabbie T. 10 points N/A #169163

Few Steps To Move A Database: MS Access to SQL Server Migration

Follow these steps to perform the Access to SQL Migration.

1. You have to make a new SSMA Project. After that, set the project options that include migration, conversion operations and, data type mappings.

2. Now you have to add Access database files to the project.

3. You have to establish the Connection to the target instance of SQL Server.

4. To customize the mapping Access databases with SQL Server, perform the mapping of the source and target databases.

5. You can create an assessment report to check whether you can perform the migration your access database to the SQL Server or not.

6. Perform the Conversion of the objects of the Access database to SQL Server.

7. Start the loading process of the Access database to the SQL Server.

8. Transfer Access Data to the SQL Server.

About Gabbie T.

Questions
7

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/08/2016
• Question Category: MS SQL Server