3xnano
Home page News > General News > MySQL Linked Server Connection Permanent link to this page

Syndicate


Valid XHTML 1.0 Transitional

Follow us on Twitter

Follow kkourentzes on Twitter

GoogleBox

GoogleChat


Latest News

MySQL Linked Server Connection
Export to PDF Permanent link to MySQL Linked Server Connection Email Print
Written by Administrator
Saturday, 15 December 2012
-- Create Link Server     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=db; USER=root; PASSWORD=password; OPTION=3'     -- Import Data from MySql to MSSQL   SELECT * INTO MSDB.dbo.contacts  FROM openquery(MYSQL, 'SELECT * FROM db.contacts') 



Uses official MySql ODBC driver (5.1) (get it here)


Last updated ( Saturday, 15 December 2012 )



0 Comments
Your name :

cool wink smile shocked sick angry blink sad unsure kissing w00t grin
silly pinch sideways whistling devil dizzy blush cheerful wassat ermm laughing tongue
Your comment :

Text remaining :


   
 

GoogleAds

SpiceWorks

Free Networking Monitoring Software For Network Management