MySQL Forums
Forum List  »  Microsoft SQL Server

Re: SQL Server to MySql
Posted by: Josh Chamas
Date: December 29, 2004 01:33PM

poongkundran paranthagan wrote:
> how to migrate sqlserver to mysql

You might try using MS SQL DTS service to move data to an ODBC MySQL connection.

You might also use a program like

You could also write your own JDBC, ODBC, or DBI tool to do it for you.

Finally, if you can export the data as a CSV or tab delimited file, you can use MySQL mysqlimport command to import the data on a per table basis. The SQL Server BCP tool can be used to get a TAB delimited export that you can feed into mysqlimport.



Josh Chamas
Director, Professional Services
MySQL Inc.,
Get More with MySQL!

Options: ReplyQuote

Written By
December 21, 2004 05:45AM
December 22, 2004 03:52AM
December 22, 2004 01:53PM
Re: SQL Server to MySql
December 29, 2004 01:33PM
December 26, 2004 11:12PM
December 27, 2004 11:16PM
December 27, 2004 11:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.