CODEWITHSUNDEEP
mysqlazureazure-sql-databasedatabase-migrationazure-mysql-database
Ian
Ian

Reputation: 3149

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.

Upvotes: 0

Views: 929

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

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.

Upvotes: 1

Related Questions