Imagine that you have db in AWS RDS and you need migrate it to Azure SQL databases.
This trick is really easy to do with Microsoft Data Migration Assistant(DMA).
1. Download and install tool.
2. Create empty DB in Azure services
3. Open tool and create a new project.
3.1 You can start with Assessment project to ensure that you don’t have any critical incompatibilities that preclude migration to PaaS platform.
DMA checks for compatibility issues and feature parity in the database to determine what, if anything, needs to be done to migrate any features in the SQL Server instance to PaaS.
Do all steps it propose, its really easy.
3.2 Create migration project set its parameters:
3.4 Create db connection to Azure sql DB and choose DB press next
3.5 Select object part: DMA will perform a quick assessment and present you with a list of the schema objects that you can migrate, with highlighting\marking to identify any objects that may have issues. Press Generate SQL script. And select Deploy Schema to apply the script via the tool.
3.6 After schema deployment finishes, we can proceed with data migration by selecting "Migrate data" button. Next, pick the tables that you want to migrate, and then select "Start data migration" button.
3.7 Wait till tool finishes its work. And you are done!
This trick is really easy to do with Microsoft Data Migration Assistant(DMA).
1. Download and install tool.
2. Create empty DB in Azure services
3. Open tool and create a new project.
3.1 You can start with Assessment project to ensure that you don’t have any critical incompatibilities that preclude migration to PaaS platform.
DMA checks for compatibility issues and feature parity in the database to determine what, if anything, needs to be done to migrate any features in the SQL Server instance to PaaS.
Do all steps it propose, its really easy.
3.2 Create migration project set its parameters:
Project name: AWSToAzure3.3 Create db connection to EC2 and select DB to migrate: set servername, user, password, dbname
Source: SQL Server
Target server type: Azure SQL Database
Migration scope: schema and data
3.4 Create db connection to Azure sql DB and choose DB press next
3.5 Select object part: DMA will perform a quick assessment and present you with a list of the schema objects that you can migrate, with highlighting\marking to identify any objects that may have issues. Press Generate SQL script. And select Deploy Schema to apply the script via the tool.
3.6 After schema deployment finishes, we can proceed with data migration by selecting "Migrate data" button. Next, pick the tables that you want to migrate, and then select "Start data migration" button.
3.7 Wait till tool finishes its work. And you are done!
Комментариев нет:
Отправить комментарий