Migrating a MySQL DB to SQL 2005

[Ovatvvon]

Hi Everyone,

I do not have any experience with MySQL, and limited SSIS experience. I have a client that is going to need to migrate their MySQL database to SQL 2005, and I was curious if anyone has had any experience doing this in the past. Does anyone know if SSIS would be able to copy all schema and data effectively from MySQL? Has anyone done it before?

Any and all help would be greatly appreciated!

Thank you!


-Ovatvvon :-Q

 

[mrdenny]

The data, yes it will move with little problem. You may need to convert the data using a data conversion step within your data movement task in order to get the data into SQL correctly as some data types don't have direct versions between the two.

As for the schema, you'll probably need to use the MySQL tools to script out the schema and then adjust the datatypes and syntax as needed so that SQL will take it.

The bigest problem area will probably be any stored procedures as there are quite a few MySQL only features which won't be supported in SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog