MySQL Forums
Forum List  »  Microsoft SQL Server

Re: SQL Server to MySql
Posted by: Josh Chamas
Date: December 26, 2004 11:12PM

Mohsin Naeem wrote:
> I am new in Mysql I want to transfer my Database
> from SQL Server to Mysql. What can I do for it
> help me please. Please tell me some method to do
> that.

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

You might also use a program like http://www.convert-in.com/mss2sql.htm

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.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Written By
Posted
December 21, 2004 05:45AM
December 22, 2004 03:52AM
December 22, 2004 01:53PM
December 29, 2004 01:33PM
Re: SQL Server to MySql
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.