MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Migrate MS SQL to MySQL
Posted by: Josh Chamas
Date: December 27, 2004 12:24AM

jferrero wrote:
> Hello.
>
> I am a beginer and I have to accomplish the
> following task.
> Install MySQL under linux.
> Then I have to migrate a unique table from MS SQL
> 2000 into the MySQL.
>
> Could someone help me giving me some tips.
>
> Thank a lot!

For the installation part:

http://dev.mysql.com/doc/mysql/en/Installing.html

For the migration part...

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 09, 2004 02:02AM
Re: Migrate MS SQL to MySQL
December 27, 2004 12:24AM


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.