up vote 0 down vote favorite
share [g+] share [fb]

I have a MSSQL DB, and would like to convert it to a MySQL DB so I could browse it from Ubuntu. What packages/tools do I need to install and what are the steps for achieving this? Thanks

link|improve this question
have you tried these suggestions? stackoverflow.com/q/129/1067827 – Fox Dec 6 '11 at 12:41
you can also "browse" an SQL Server database from Ubuntu without exporting/importing into MySQL. There might be better options, but squirrelsql.org + SQL Server JDBC driver will let you connect to the db, which might be a more practical option. – alex Dec 6 '11 at 12:50
feedback

1 Answer

up vote 0 down vote

Your best bet is to export the MSSQL data in a common format, such as CSV, and them import it into mysql.

You use bcp to export data from MSSQL into custom-format files; on the mysql side, use LOAD DATA or the equivalent.

The schema is another matter; since the SQL dialects are wildly different, this will require manual manipulation of the MSSQL schema output.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.