Help with migrating data from Mysql into SQL Server 2008 using SSIS

• kingdonshel

  SSCommitted

  Points: 1704

  More actions

  July 3, 2010 at 3:49 am

  #141844

  Novice at SSIS: I want to Import data from a database in Mysql to SQL 2008 I read its best to do it one table at a time. But I would like to keep my database structure intact from Mysql (foriegn Keys, Cascade on delete , Primary keys) etc. Can anyone Provide step by step instructions. The only way I can see the source database (Mysql) is by using the ADO Net source ITEM on the Data Flow Tab and the ADO Net Destination.

  When I try to set the connection to the (Destination) SQL Server instance I am only able to view tables already in that database if I try to map the tables from the Mysql source, I end up seeing only columns already in the destination table, the new button is also greyed out so I cannot create a new table and try to map tables

  If anyone has been able to successfully transfer data from Mysql to SQL Server 2008 I would really appreciate some step by step instructions on how its done.

  Thanks

• Alexander G.

  SSCrazy

  Points: 2705

  More actions

  July 5, 2010 at 9:10 am

  #1188807

  SSIS is more suitable for data transfer (like DML) and not to transfer object definitions (like DDL).

  Have you already tried the Import/Export wizard from management studio (context menu of a database -> tasks)? This wizard can also create the appropriate DDLs (although I have to admit that I haven't used it with mysql).