data

Question

data

HBK_4700

SSCrazy Eights

Points: 8932
More actions
May 14, 2010 at 7:31 am

#218910

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

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.

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 2

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

SQLBalls SSCarpal Tunnel Points: 4621 More actions · Answer 3

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