MSSQL 連結 MYSQL (Linked Server)

JDP

• 首先安裝 Connector/ODBC 5.2.4 (選用沒有ansi的，支援Unicode)
• SQL Server Management Studio => "連結的伺服器"=> 提供者 => MSDASQL =>屬性 =>勾選圖中四個選項
  
• 執行以下指令
  
  1. exec sp_addlinkedserver @server = N'mahara',@srvproduct=N'MySQL',@provider=N'MSDASQL',@provstr=N'Driver={MySQL ODBC 5.2w Driver};Server=192.168.1.3;Database=mahara;User=mahara;Password=xxxxxxx;Option=3';

  複製代碼
• 之後使用 select * from mahara...tablename 即可進行查詢
  

Reference:
MSSQL LINK MYSQL(2-2 實作篇)
http://paco8822.pixnet.net/blog/post/3391812
MSSQL LINK MYSQL(2-1 DEMO篇)
http://paco8822.pixnet.net/blog/post/3299574
MySQL Linked Server on SQL Server 2008
http://www.packtpub.com/article/ ... -on-sql-server-2008
MySQL Data Transfer using SQL Server 2008 Integration Services (SSIS)
http://www.packtpub.com/article/ ... ation-services-ssis
Link MySQL to MS SQL Server2008
http://dbperf.wordpress.com/2010 ... -ms-sql-server2008/
HOWTO: SQL Server 2005 to MySQL 5 Linked Server UPDATE
http://forums.mysql.com/read.php?60,124480,124480#msg-124480
How-To: MySQL as a linked server in MS SQL Server 2000
http://developer.infi.nl/index.php?ID=6&article=6
SQL Server 2008通過LinkServer連接MySQL
http://tc.itkee.com/database/detail-1cab.html
Simple migration from MySQL to SQL Server Express 2005?
http://social.msdn.microsoft.com ... 0-a452-6b5f462bd911