hi friends,
I need to move all data from mysql database to sql server database every 24 hours . is it possible by sql server 2000 query or sp by using job scheduling ? plz help . its urgent . if possible plz provide sample query or sp to do this.

regards,
max

Hi Max,

I don't know a whole lot about MySql, nor do I know if there is a MySql odbc type driver.

You did not specify the size of the database (how many tables, etc), but if I were you, I would investigate the possiblity of 1 of the following 2 options, based on the size of the database

1) See if MySql can export the data to a specific format and have SQL Server import that data.
2) Possibly see if you can attach the MySql database to SQL Server and schedule a DTS job to move/copy the data from the MySql database to a SQL Server database.



Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

If you need to move data that often, why not just use SQL Server and avoid MySQL altogether?

--Jeff Moden

licensing costs is a good reason to use Mysql. I am not sure I follow your question but why don't you just use dts? Just requires an ODBC connection to your mysql database. Real question is why not just use Mysql for everything?

Licensing is a capital expense that can be written off but Robprell and I both have the correct idea... why not just do everything in one RDBMS or the other?

--Jeff Moden