MS Sql Server to MySQL

[mattb]

I am looking for a best practice or any recommendations for uploading data from a local MS SQL Server to a hosted MySQL server. Currently our store management system is being written in MS SQL Server and we would like store the products for the website on a MySQL Server that is located at our host. We are looking for a solution that is easily portable so that we can move hosts easily. The MySQL Server is a shared server and can only be accessed from the web server box that our site is hosted on.

Any ideas?

Thanks,

Matt

[bakedjake]

Install MyODBC on your MS-SQL Server, and use the DTS Export tool from Enterprise Manager to export the data to your hosts' MySQL machine.

[sun818]

Do you know if the export tool has a command line interface for unattended processing? I would also look at DBcopy.com - They have a tool which can automate exporting from Access to mySQL. In your case, you your Access would be linked to all the MS SQL Server tables you wanted to export. Same idea as bakedjake - just different and costs more. ;)

[bakedjake]

sun - dtsrun is a command line version of the DTS Export tool for SQL Server. So you can build the package, and then execute it from cmd or automate/schedule it or whatever.

[msdn.microsoft.com...]

[sun818]

The mySQL ODBC driver is here:
[mysql.com...]

As with any conversion, I suggest you validate the values in mySQL against SQL Server thoroughly.