DB Migration

Taking care of your Linux box.
Posts: 69
Joined: Wed Dec 06, 2006 3:51 pm

DB Migration

Postby refra » Wed Nov 26, 2008 4:57 pm


My DB server is running on MSSQL. I install linux server with MySQL as a DB server.

Now i want to migrate whole MSSQL based DB to MySQL.

How can i do this ?

Major General
Posts: 3452
Joined: Tue May 27, 2003 7:04 pm
Location: Lahore

Postby lambda » Wed Nov 26, 2008 7:33 pm

if it's not a lot of tables, the easiest way is to create the same db tables in mysql, and then to dump the table data in csv format, and import using mysqlimport.
Watch out for the Manners Taliban!
Isn't it amazing how so many people can type "linuxpakistan.net" into their browsers but not "google.com"?

Return to “Administration”

Who is online

Users browsing this forum: No registered users and 0 guests