DB Migration

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

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 ?

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

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