mySQL MS SQL advice?

[Anon]

Hi,

my web site is generated from a mySQL db which all runs on a remote server. I have a local NT server running MS SQL which is not online 24 hours a day.

Is it possible to transfer data from the web site to the MS SQL server? (which is offsite and sometimes offline) How?

Thanks for any advice,

Clas

[[deleted]]

mysqldump.

That lets you dump the database-data in a csv-like format that you should be able to import into ms-sql.

[brandonschnell]

or you can install the mysql odbc drivers from www.mysql.com and import the data using ms sql server.