Bulk copy to a MySQL server

Bulk copy to a MySQL server

Postby 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
phburke
 
Posts: 3
Joined: Sun 22 Feb 2009 22:57

Postby Shalex » Thu 18 Jun 2009 11:48

We recommend you to use either the MySqlDump component (MySQL <-> MySQL), or SSIS (MS SQL <-> MySQL).
Shalex
Devart Team
 
Posts: 7340
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Thu 18 Jun 2009 11:58

Be aware, SSIS works only with data, and it doesn't create constraints.
Shalex
Devart Team
 
Posts: 7340
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL