DB Migration

Taking care of your Linux box.

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 ?
Posts: 69
Joined: Wed Dec 06, 2006 3:51 pm

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"?
Major General
Posts: 3452
Joined: Tue May 27, 2003 7:04 pm
Website: http://www.hungry.com/~fn/
Location: Lahore

Return to “%s” Administration

Who is online

Users browsing this forum: No registered users and 1 guest