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
ASKER CERTIFIED SOLUTION
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