How to Migrate SQL Server (On-Prem) to Azure SQL Database offline using DMS tool.
Hello Friends, today we will learn how do we migrate a On premises SQL Server to PaaS model SQL Azure database.
To achieve this, we need to follow few basic steps i.e. prerequisites.
Before you can migrate data from an on-premises SQL Server instance to a single database or pooled database in Azure SQL Database, you need to assess the SQL Server database for any blocking issues that might prevent migration. Using the Data Migration Assistant v3.3 or later.
Download link for DMA :
https://technorhythms9.blogspot.com/2020/05/how-to-download-dma-database-migration.html
https://technorhythms9.blogspot.com/2020/05/how-to-download-dma-database-migration.html
1. Select the New (+) icon, and then select the Assessment project type.
2. Specify a project name, in the Source server type text box, select SQL Server, in the Target server type text box, select Azure SQL Database, and then select Create to create the project.
3. On the Select sources screen, in the Connect to a server dialog box, provide the connection details to your SQL Server, and then select Connect.
4. In the Add sources dialog box, select your database, select Add, and then select Start Assessment.
5. Select Under Migration Scope, select Schema only.
6. In the Data Migration Assistant, specify the source connection details for your SQL Server, select Connect, and then select your target database.
7. Click on Connect.
8. Select the objects that you want to migrate. By default, all objects are selected.
9. Select Generate SQL script to create the SQL scripts, and then review the scripts for any errors.
10. Select Deploy schema to deploy the schema to Azure SQL Database, and then after the schema is deployed, check the target server for any anomalies
You are almost done!
Now, you will need to create a SQL database in Azure portal.
Refer my another page to create a Sample SQL database:
Well, once SQL database created in Azure,
1. In the Azure portal menu or on the Home page, select Create a resource. Search for and select Azure Database Migration Service.
2. Create a new Migration project.
Now, we are in final stage:
1. Now, select the source, target details
2. Select the objects that you want to migrate into Azure or All objects
3. Specify a name for the migration activity.
4. Review the migration summary if the information selected right.
Run the migration and monitor the progress.
5. After the migration completes, select Download report to get a report listing the details associated with the migration process.
6. Verify the target database(s) on the target Azure SQL Database server
That's it. Sit back & relax!
Do follow my other topics & share with your friends.
Comments
Post a Comment