sql server链接服务器增加mysql

  链接字符串是：

Driver={MySQL ODBC 5.3 Unicode Driver};Server=127.0.0.1;Database=test; User=root;Password=Password01!;Option=3;

这个和执行下列sql类似：

EXEC sp_addlinkedserver
    @server = 'MySQL',
    @srvproduct='MySql' ,
    @provider = 'MSDASQL',
    @provstr = 'Driver={MySQL ODBC 5.3 UNICODE Driver};
    Server=localhost;
    Database=test;
    User=root;
    Password=Password!;
    Option=3;'

然后增加访问权限：

 EXEC sp_addlinkedsrvlogin 
     @rmtsrvname='MySql' ,
     @useself='false' ,
     @locallogin='sa' ,
     @rmtuser='root' ,
     @rmtpassword='Password!'
     

这个是增删改的访问mysql的命令

SELECT * FROM OPENQUERY (mysql ,'select * from sugarcrmtable')

INSERT OPENQUERY (mysql, 'SELECT * FROM sugarcrmtable') VALUES ( '5');

DELETE OPENQUERY (mysql, 'SELECT * FROM sugarcrmtable WHERE idsugarcrmtable = 5');

这个是显示触发器的命令：

show triggers