Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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? – 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 + 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

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


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.