Synchronizing data from SQL 2000 with MySQL

[YvonneTsang]

I was wondering how difficult it would be to synchronize data from SQL 2000 with MySQL. I assume that XML would allow me to do this. I have done with different SQL versions but never MySQL. Is it much different?


Thanks

Yvonne

 

[lemosley01]

You might be able to use SQL Server's replication facilities to push the data to MySQL. If MySQL is the source, then you could create a DTS package to import the data and schedule it to run periodically.
Another option is to use linked servers (see linked servers in SQL Books Online).