copy from mssql to mysql

[had1980]

Hi,
I have a mssql database, so i want to copy some data from it to a mysql databse(both on the same server), so can i do something like synchronization system??, that read from the mssql database, and insert into the mysql database???

thanks

[archangel_617b]

I do no know if this is what you want, but you should be able to dump the contents of you mssql db. I do this a lot in mysql for backup (mysqldump is the command) and the output is plain SQL (and thus usable in almost any db).

You should look into what is available for mssql for it. mysqldump will every dump specific tables, a whole db, several dbs... You name it, it will do it. mysql can be told to simply execute an SQL file:

mysql -Ddb -uuser -ppassword -e ". sqlfile.sql"

And so it can be run in a script which cron can execute regularily.

I'd be glad to help with the mysql/cron end (though you should check the man pages on those first), but I cannot help you with any tools mssql may or may not provide for dumping data.