I need either a Windows or Linux program or even a DTS package that can be ran as a scheduled task or through a cron job. I need to be able to dump parts of my MS SQL server database to a MySQL database on my webserver.
The problem is that the source (MS SQL) contains some text fields with over 8000 characters and DTS generates "query based insertion of blob values is not supported" errors.
Preferably I would be able to select the source / tables (MS SQL) and the destination / tables (MySQL) and set the time(s) the data transfer would occur. Before each table is transfered, it would first truncate the destination table before any rows are inserted.