troubleshooting Question
best way to migrate a MySQL DB to MSSQL 2005
Hi there,
I'm migrating an application from an older Mac Server onto a new Win 2008 server to be shared with sharepoint. Hence we need to migrate the DB.
I've created a test VM with same SQL 2005 config and installed MySQL with source DB.
Have been trying for a couple of days now to use SSIS to import the data but are having many problems with this.
I've just done a mysql dump using phpmyadmin and noticed / set compatibility option to MSSQL and saved it to a .sql file. I'm assuming this option is only to help minimize problems with the datatype differences such as varchar length etc..
What would be a good way to import this?
DB is about 600MB and contains ~240 tables
I'm migrating an application from an older Mac Server onto a new Win 2008 server to be shared with sharepoint. Hence we need to migrate the DB.
I've created a test VM with same SQL 2005 config and installed MySQL with source DB.
Have been trying for a couple of days now to use SSIS to import the data but are having many problems with this.
I've just done a mysql dump using phpmyadmin and noticed / set compatibility option to MSSQL and saved it to a .sql file. I'm assuming this option is only to help minimize problems with the datatype differences such as varchar length etc..
What would be a good way to import this?
DB is about 600MB and contains ~240 tables
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.