usin mssql db with Linux

zolf
zolf used Ask the Experts™
on

Hello there,

i have been using windows server 2003 and mssql 2005 db for my java application.now i am thinking to switch to linux.i want to know can i install mssql server 2005 on linux.if not how can i migrate my mssql db tables wth data to mysql db.appreciate your help.

cheers
zolf
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
You can save the mssql database as a SQL script and then you can run that script in mysql db to import all data and the tables  

Author

Commented:

You can save the mssql database as a SQL script and then you can run that script in mysql db to import all data and the tables  

can you please guide me with more details please.
Commented:
MSSQL surprisingly enough, will not run on Linux.

First of all, not everything will migrate from MSSQL to MySQL. The database engines do not support the same features.

If all you have is tables and simple contents, the export and import should be relatively straightforward. You will have to first export the database from MSSQL as SQL, then check that the syntax is correct for MySQL and import. This option really requires that you know what you are doing.

Import/Export by hand is not the only option though. There are a few commercial options for DB migration, and some open ones. One of the open ones is the MySQL Migration Toolkit: http://dev.mysql.com/doc/migration-toolkit/en/index.html

The commercial products like http://www.spectralcore.com/dlsubscribe.php?product=fullconvert are easier to use, but you also have to pay. If you are doing this for your employer, I strongly suggest using a commercial product where you can get professional support. The price is nothing compared to the number of hours you will have to spend to make everything work flawlessly manually (assuming the DB is big).

If you have an application running against your DB, you will also have to check the compatibility with MySQL before migrating the data.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial