May 14, 2010 at 7:31 am
how can we send data from sqlserver(windows) to mysql(linux).
I want to send data from sqlserver db to mysql db (one way)
Please advice
May 14, 2010 at 7:36 am
Integration Services has OLEDB drivers to connect to other sources. If you can make a connection from the Windows machine to MySQL, you can build a package and send data across.
May 14, 2010 at 7:45 am
Do you have the ODBC connection installed on the server for MySQL?
you will need to create a linked server to the MySQL DB
I have a MySQL DB I import from using openquery.
http://msdn.microsoft.com/en-us/library/ms188427.aspx
openquery has the ability to perform inserts and updates as well.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
May 14, 2010 at 7:47 am
Steve Jones - Editor (5/14/2010)
Integration Services has OLEDB drivers to connect to other sources. If you can make a connection from the Windows machine to MySQL, you can build a package and send data across.
This could work quite well, I was on a tight deadline and had issues getting SSIS to work, real tight got the word of what was needed at 4:45 pm on a Friday, and by 1:30 AM on Saturday had it running.
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply