0

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.

Ian
  • 2,898
  • 1
  • 27
  • 29

1 Answers1

1

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.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23
  • Thanks for your suggestion - I looked into data factory but couldn't see how to achieve MySQL to MS SQL migration. Could you edit you answer to detail 'how'? cheers – Ian Oct 06 '20 at 08:41
  • Perfect thanks! I would add for the benefit of other that it's likely the mapped types will need changing to suit Sql Server. – Ian Oct 07 '20 at 08:36