Convert Azure MySQL database into a Azure SQL Server database

Question

There are a few guides on how to migrate a MySql database to Azure SQL Server - on premise - but I was thinking there may be a more automated way to achieve converting an Azure MySql instance into an Azure SQL Server.

Does anyone have any guidance/links to achieve this?

Many thanks!

Ian

Answer 1

Hi @i.klek , welcome to Microsoft Q&A community.

To answer your query, unfortunately there is no direct or automated way of achieving the migration or converting the Azure Mysql database into Azure Sql database.

However, using 'Sql Server Migration Assistant for MySQL' tool it becomes very straight forward as it gives you both source and target database where in we can choose Azure Mysql and Azure Sql database respectively. Please refer to the link for more details. Below is the screenshot of the same tool.

Another way is to achieve this is using Azure Data Factory. You can refer to below link for more details:
https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-database-for-mysql

You might have already looked into these but please let us know if you need any help with these and we can continue our discussion.

Answer 2

The MySQL to MSSQL Converter software allows you to migrate all database from MySQL Server into MYSQL Server without any data loss. It migrates table, database, and items from MySQL Server successfully.