Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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

share|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

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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