mysqlazureazure-sql-databasedatabase-migrationazure-mysql-database

How to migrate Azure MySql database to Azure MS SQL Database


It's clear on how to migrate on-premise or RDS MySql database to Azure MS Sql, using Data Migration Assistant for MySql or the azure Database Migration Service, but absolutely nothing for Azure MySql to Azure Sql.

What is the best way to migrate Azure MySql to Azure SQL database?

Only option so far is having to download my Azure MySql database to a local instance then use the Data Migration Assistant for MySql tool to upload to Azure SQL.


Solution

  • I don't know what is the best way you want, but I guess that you want migrate the database online and without client tools.

    Maybe you could think about Data Factory, it's always used to migrate the database. It can help us auto create the table and schema.

    Please reference the tutorials below:

    1. Copy data to and from Azure Database for MySQL using Azure Data Factory
    2. Copy and transform data in Azure SQL Database by using Azure Data Factory

    The easiest way is that you can use Copy data.

    Follow these steps:

    Copy data tool: enter image description here

    Create new connection to Azure SQL Database for MySQL: enter image description here

    Select all tables in the Azure MySQL: enter image description here enter image description here

    Create the Azure SQL database as Destination data store: enter image description here

    Table mapping, auto create: enter image description here

    Column mapping: enter image description here

    Next run the copy tool step by step.