DB Migration

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

DB Migration

Post by refra »

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 ?
Top
lambda
Major General
Posts: 3452
Joined: Tue May 27, 2003 7:04 pm
Location: Lahore
Contact:
Contact lambda

Post by lambda »

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"?
Top
Post Reply

Return to “Administration”