ä¸.为 MySQLå®è£
ODBC驱å¨
2. ä»æ§å¶é¢æ¿-管çå·¥å
·ï¼æå¼ä½ ç æ°æ®æº(ODBC)ï¼é ç³»ç»DNS ,ç¹æ·»å ã
3. å¨ å建æ°æ°æ®æºå¯¹è¯æ¡ä¸ï¼éæ©MySQL ODBC 5.1 Driver ï¼ç¹å®æã
4. å®æåä¼åºç°MySQL é¾æ¥å¯¹è¯æ¡ï¼æ·»å ä½ ç MySQL æ°æ®åºè´¦å·ä¿¡æ¯ï¼å¹¶ç¡®è®¤"root"è´¦å·æ¯å¦æå
¨é¨çæéï¼å¦æä½ å®è£
MySQL 没æä¿®æ¹çè¯ï¼ ä¸è¦æ¹ 3306è¿ä¸ªç«¯å£å·ã
5. ç¹âæµè¯âæé®ç¡®è®¤ä½ çé¾æ¥æ¯æ£ç¡®çã
Press the "Test" button to ensure your connection settings are set properly and then the "OK" button when you're done.
äº. å建Microsoft SQLå°MySQLçé¾æ¥
1.å¨SQL Server Management Studioä¸æå¼ä¸ä¸ªnew query æ·è´ä¸ä¸è¯å¥ï¼ä¿®æ¹ä¸ºä½ çæ°æ®åºçå称ï¼å¹¶è¿è¡ã
EXEC master.dbo.sp_addlinkedserver
@server = N'MYSQL',
@srvproduct=N'MySQL',
@provider=N'MSDASQL',
@provstr=N'DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; _
DATABASE=tigerdb; USER=root; PASSWORD=hejsan; OPTION=3'
2.è¿ä¸ªèæ¬éè¿ODBC驱å¨å建ä¸ä¸ªèæ¥å°ä½ çMySQLæ°æ®åºï¼è¿ä¸ªèæ¥åºç°å¨Microsoft SQL Server
ä¸. å¨ä¸¤ä¸ªæ°æ®åºä¹é´å¯¼æ°æ®
å¨Microsoft SQL Serverä¸å建个æ°çæ°æ®åºï¼å¦ï¼testMySQlï¼ï¼å¨new queryä¸æ·è´å¦ä¸è¯å¥ï¼è¿è¡åå°±å¯ä»¥æMySQL æ°æ®åº âtigerdbâ 导å
¥å° Microsoft SQL æ°æ®åºâtestMySQlâä¸ã
SELECT * INTO testMySQL.dbo.shoutbox
FROM openquery(MYSQL, 'SELECT * FROM tigerdb.shoutbox')
温馨提示:答案为网友推荐,仅供参考