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.