Connect to MySQL from SQL Server
from the Artful MySQL Tips List
There are a variety of ways to connect from SQL Server to MySQL/MariaDB, eg ...
- use SQL Server Management Studio (SSMS) to set up a linked server to a MySQL instance; an example is described at http://forums.mysql.com/read.php?60,13209,130975#msg-130975/url>
- Easysoft has an ODBC/JDBC gateway
- SQL Server Integration Services (SSIS) supports direct management of MySQL databases, see an example setup
SQL Server now being available on Linux opens up another possibility: With both MySQL and SQL Server installed on a Linux system, it may be possible, eventually to access MySQL databases directly via sqlcmd. But it isn't yet.
Return to the Artful MySQL Tips page