Bug #66628 Migration fail on large schemas
Submitted: 30 Aug 2012 22:07 Modified: 30 Aug 2012 22:21
Reporter: Andre Bechara Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:5.2.42 CE OS:Windows (7 Home Basic)
Assigned to: CPU Architecture:Any
Tags: migration, workbench

[30 Aug 2012 22:07] Andre Bechara
Description:
The migration stops when you try to migrate data from a schema with a lot of tables (300+).

How to repeat:
Try to migrate a schema with a lot of tables.

Starting...

Prepare information for data copy...

Prepare information for data copy done

Determine number of rows to copy....

Counting number of rows in tables...

wbcopytables.exe --count-only --passwords-from-stdin --odbc-source=DRIVER={SQL Server Native Client 11.0};SERVER=xxxx.jus.br\SQL2;DATABASE={SEI_mysql};UID=xxxx --table [SEI_mysql] [dbo].[seq_moeda] --table [SEI_mysql] [dbo].[infra_auditoria_usuario] --table [SEI_mysql] [dbo].[auditoria] --table [SEI_mysql] [dbo].[bkp_categoria_texto_pronto]   ...

Command line too long.

*** ERROR: Determine number of rows to copy: Error getting row count from source tables

Failed
[30 Aug 2012 22:21] MySQL Verification Team
Thank you for the bug report. Duplicate with bug: http://bugs.mysql.com/bug.php?id=66611 .