DB Migration

Taking care of your Linux box.

DB Migration

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

AOA,

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 ?
refra
Naik
 
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"?
lambda
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: Yahoo [Bot] and 1 guest

cron