Azure SQL Video
9 page views
2068 video views
2024, May 07, Tuesday

#109 How to Migrate Data from MySQL to Azure SQL Database

How to migrate existing tables and data from MySQL database to Azure SQL Database using the Migration Assistant tool

We will know the techniques:

🔹Download and install the Migration Wizard and the MySQL Driver for Windows;
https://www.microsoft.com/en-us/download/details.aspx?id=54257
https://dev.mysql.com/downloads/connector/odbc
🔹Create new migration project for Azure SQL Database (NEW PROJECT, MIGRATE TO)
🔹Get schema objects in the My SQL database (CONNECT TO DATABASE);
🔹Get schema objects in Azure SQL Database (CONNECT TO DATABASE); Migrate objects to the destination
database (CONVERT SCHEMA, SYNCHRONIZE WITH DATABASE); Migrate data from the tables to the destination database (MIGRATE DATA); 🔹
🔹
🔹Change table after schema migrated;
🔹View structure in the target database (SSMS, SELECT).