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.
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.
