troubleshooting Question

best way to migrate a MySQL DB to MSSQL 2005

Avatar of edukate
edukate asked on
PHPMySQL ServerMicrosoft SQL Server 2005
15 Comments1 Solution529 ViewsLast Modified:
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
Faiga Diegel
Sr Database Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros