Converting MySQL Db to SQL Server 2005

[JohnBates]

hi everyone,

Does anyone have any real-world experience with converting a MySQL database to SQL Server 2005?

I know it may depend on the complexity of the MySQL db, the various features it is using.

I found an old (2001) whitepaper from Microsoft that describes how to convert to SS2000 but that may not relate very well to 2005.

I'm sure Integration Services would be the tool to use but
how difficult and what are some gotchas to watch out for?

Thanks, John

 

[mrdenny]

The paper that you say will probably still be correct.

SSIS (Integration Services) will be what you use to actually move the data from the MySQL database to the SQL Server database after the new Schema has been setup and you are ready to move the data over.

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