SQL Server connect to MySQL SQL Server access MySQL database via Linkserver

SQL Server requires access to MySQL data, which can be implemented by invoking MySQL's ODBC driver and adding linkserver in SQL Server.

1. Download the latest MySQL ODBC driver from the MySQL website: http://www.mysql.com/downloads/connector/odbc/, the current version is 5.3.9

2. Install on the server where SQL Server is located

3. System dsn--Add

4. Establish linkserver in SQL Server, which can be implemented using the following script:

EXECMaster.dbo.sp_addlinkedserver@server =N'Mysqllink',@srvproduct=N'Mysql',@provider=N'Msdasql',@datasrc=N'MySQL'--MySQL Here is the name of the data source you just builtEXECMaster.dbo.sp_addlinkedsrvlogin@rmtsrvname=N'Mysqllink',@useself=N'False',@locallogin=NULL,@rmtuser=N'Root',@rmtpassword='123456'

5. Perform query validation

SELECT *  from OPENQUERY ' SELECT * FROM TableName ')

SQL Server connect to MySQL SQL Server access MySQL database via linkserver