July 3, 2010 at 3:49 am
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
July 5, 2010 at 9:10 am
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).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply