MSsql ---> Mysql

[TheKnee]

Hi i would like to update data in MYSQL with data are stored into MSSQL,
I have the Mysql odbc driver install, i could export to MySQL, it's work fine

i would like to do a Update qwery sotred in a job like every hour from MSSQL to Mysql is it possible???


Im working with Enterprise manager for Mssql and naviacat for Mysql

 

[dhulbert]

You need to look at creating a DTS package to export the data then you can schedule the package as a job that runs reguarly



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[mrdenny]

You'll want to setup a linked server from the MSSQL server to the MySQL server, and use that to update the data.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)