找回密碼
 註冊
搜索
查看: 9520|回復: 0

MSSQL 連結 MYSQL (Linked Server)

[複製鏈接]
發表於 2011-4-7 08:49:00 | 顯示全部樓層 |閱讀模式
  • 首先安裝 Connector/ODBC 5.2.4 (選用沒有ansi的,支援Unicode)
  • SQL Server Management Studio => "連結的伺服器"=> 提供者 => MSDASQL =>屬性 =>勾選圖中四個選項
    mssqllinkmysql1.png
  • 執行以下指令
    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
您需要登錄後才可以回帖 登錄 | 註冊

本版積分規則

Archiver|手機版|彩色筆小沛的知識庫

GMT+8, 2024-3-29 14:23 , Processed in 0.023635 second(s), 12 queries , Gzip On, MemCache On.

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回復 返回頂部 返回列表