Page 1 of 1

Bulk copy to a MySQL server

Posted: Wed 17 Jun 2009 16:36
by phburke
Is there a way to bulk copy a table from one MySQL server to another MySQL server? Or from a MSSQL server to a MySQL server?

Thanks,
Pat

Posted: Thu 18 Jun 2009 11:48
by Shalex
We recommend you to use either the MySqlDump component (MySQL MySQL), or SSIS (MS SQL MySQL).

Posted: Thu 18 Jun 2009 11:58
by Shalex
Be aware, SSIS works only with data, and it doesn't create constraints.