A link to mysql database in sql server without installing mysql driver on sql server database server,is it possible?

Martin Wang 106 Reputation points

I would like make a link of mysql in sql server,it seems that I need to go to sql server database server and install a mysql odbc driver, is it possible to realize it without installing amything on sql server database server?
I hope i have clearly explained my question, otherwise please replying me so i could explain in detail.thank you very much

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
760 questions
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee

    Hi, @Martin Wang Welcome to the Microsoft Q&A forum, and thanks for reaching out.

    In a linked server concept it is that the SQL service should have the ability to connect .. so for the MySQL database, it is just another client trying to connect... There could be multiple ways to do it ..
    but yes the SQL server should have the drivers to connect to MySQL
    The easiest way is always to use the ODBC driver in the SQL server please check this document how you can use SSMA if the intention is to bring data into SQL.

    you can also check this document on the linked server.

    Please let me know if you are looking for additional information.


0 additional answers

Sort by: Most helpful