创建MySQL的链接服务器:
use master
go
-- 删除链接服务器,如果存在此链接服务器
if exists(select * from sysservers where srvid != 0 and srvname='MYSQLLINK')
EXEC master.dbo.sp_dropserver @server=N'MYSQLLINK', @droplogins='droplogins'
go
--创建Link Server,即创建一个与MySQL交互的链接。
/****** Object: LinkedServer [MYSQLLINK] ******/
EXEC master.dbo.sp_addlinkedserver @server = N'MYSQLLINK',
@srvproduct=N'MySQL', @provider=N'MSDASQL',
@provstr=N'Driver={MySQL ODBC 5.1 Driver};Server=61.*.*.*;Database=dbName;User=root;Password=root;Option=3;'
go
--创建登录Link Server
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'MYSQLL