Bulk copy to a MySQL server

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
phburke
Posts: 3
Joined: Sun 22 Feb 2009 22:57

Bulk copy to a MySQL server

Post by phburke » Wed 17 Jun 2009 16:36

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

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 18 Jun 2009 11:48

We recommend you to use either the MySqlDump component (MySQL MySQL), or SSIS (MS SQL MySQL).

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 18 Jun 2009 11:58

Be aware, SSIS works only with data, and it doesn't create constraints.

Post Reply