SQL Server to mySQL

[Anon]

I need to transfer all data from a ms sql server db to a mySQL db every x minutes...
Is there any easy way to accomplish this.
Essentially i want to copy all tables and data over every x minutes.
Thanks.
-Randy

[flipis]

Two things. Check out for the NTEXT field type. It will give you problems when using ODBC if you dont use a query like

"SET TEXTSIZE 16864"

or something real big.

The other thing is that you can create an automated scripts that actually reads the data from one databse and puts it into the other. Write me and i'll give you some code i've got somewhere.... 🙂

Hope it helps

fLIPIS