Hi All,

Which is the best way to transfer data from MSSQL server to MySQL DB?

The objective is to transfer data on a daily basis (for now weekly)from different sites to a central location (Mysql DB) that runs on linux box from which the aggregated reports are to be done. The management wants to do it this way. I have completed the work for moving all data backups and restore those into one place(MSSQL server 2000).

1) DTS : Can we do that using DTS? If possible, Can we do a differential data transfer say that day's data alone is copied into mysql db.
2) OPENROWSET : Using this I am able to transfer data into MYSQL. But kind of slow and time consuming.
3) Linked Server : Can we add mysql server as a linked server to sql server? Not sure if this is possible.

If Option 1 and 3 are possible, then all 3 options are initiated from sql server.

I am also curious to know if data transfer can be initiated from MYSQL and how optimal is that, will that be faster than I do it right now? Trying to understand the best way to do this...

Please put across your thoughts and let me follow the best way in accomplishing this.

Thanks in advance.
Cheers.

_________________________
- Vijay G
Strive for Perfection

__________________
- Vijay G