MYSQL to Azure Sql Database Connection

Question

Hi Everyone,
I am trying to create a live connection from MYSQL into Azure Sql Database so I can send part of the data there that relates to the project I am working on and perform some data analytics on them using PowerBi.

Also, whatever functions are done on Azure Sql database(ex:insert,delete) data should not affect the source data on (MYSQL).

I unfortunately can't have full access to the data on MYSQL and that's why I am considering this approach.

Just wondering what are the steps for doing that and if anyone has an idea if that would be costly and whether I should consider another approach.

Thanks

Answer 1

Hi @Ayman M,

Welcome to Microsoft Q&A forum and thanks for using Azure services.

As I understand, you want to create a live connection from MYSQL into Azure Sql Database so I can send part of the data there that relates to the project.

• If the scenario is to access part of data from MySQL then you could user Azure Data Factory/Azure Synapse Analytics pipelines and use Copy and Lookup activity which is illustrated here: Copy data from MySQL using Azure Data Factory or Synapse Analytics.
• Another approach could be to export the data of the MySQL database to a CSV file and from the CSV file to Azure SQL database using SQL Server import-export wizard demonstrated here: Export data from MySQL tables to Azure SQL database

Additional useful resources are listed below:

Quickstart: Use Azure Data Studio to connect and query MySQL (Preview)

Connecting to Azure SQL Database (MySQLToSQL)

For Migration purpose refer to: Migration guide: MySQL to Azure SQL Database

Please take a look and let us know if you face any issue while performing the connection and data transfer, thanks.

If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.