Convert Azure MySQL database into a Azure SQL Server database

i.klek 1 Reputation point
2020-10-01T10:59:09.563+00:00

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

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
671 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Anurag Sharma 17,536 Reputation points
    2020-10-01T13:07:23.537+00:00

    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.

    29616-image.png

    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.

    0 comments No comments

  2. Aleck Stewart 1 Reputation point
    2020-10-09T06:57:39.18+00:00

    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.

    0 comments No comments