Question 21976 in Mysql Question posted in
The official MySQL documentation can be found here.

How to connect Azure Database for MySQL flexible server in Azure SQL Server Database

I am trying to set up a connection between Azure MySQL flexible server and Azure SQL database mainly to read data from MySQL and store it in the SQL Server periodically (multiple times a day).

I was thinking of creating a stored procedure inside my SQL Server database; however, I cannot seem to get a connection from the SQL Server into the MySQL database.
I know with ODBC you can connect MySQL to on-prem SQL Server, but unfortunately, there is nothing I have found for the same functionality for Azure SQL Server.

Has anyone done this? Is this possible?

I have tried to set up an ODBC connection, but it did not work as the SQL Server is on Azure.

I tried setting up a linked server inside SQL Server straight to MySQL, but it doesn’t seem possible as the SQL Server is not on-prem.

I tried creating external database objects based on the following link.

With all these approaches, my expectation was to surface the MySQL tables from Azure SQL Server/SSMS.

Thank you for your help in advance!

Tags:

3

Answers


  1. Chosen as BEST ANSWER
    0

    I have had to create an Azure Function App that contains a Timer function that reads the data from the MySQL data and pushes it to SQL Server every 15 minutes (as were the requirements).

    Thank you for everyone for commenting.


  2. 0

    MySql Workbench is the perfect option for connecting the azure database for mysql.
    for that we need to create flexible server in azure portal. I created flexible server in azure portal.

    Image for reference:

    enter image description here

    I created database in flexible server by clicking add in in database option. it crated successfully.
    Image for refence:

    enter image description here

    I installed MySQL Workbench in my local system.
    you can get your required fields to connect the server in connect tab.
    Image for reference:

    enter image description here

    I connected to the server by filling required fields.
    Image for reference:

    enter image description here

    Click on ok. It connected successfully.
    Image for reference:

    enter image description here

    AFAIK Export the data from Azure mysql flexible server in the form of sql script through MySQL work bench and import that file in Azure sql database through SSMS. IN this we can write data into Azure Sql database.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search