Data Migration reports migration for each row in table

Symptom
During data migration of even very big tables, SSMA reports migration of each single data row. This slows down data migration.

Cause
ADO.NET Data Provider for Sybase has a bug in some versions, when AseCommand.ExecuteReader(CommandBehavior.SingleRow) returns AseDataReader which returns false from Read() method when called even though SQL statement returns one single row.

See http://search.sybase.com/kbx/changerequests?bug_id=485824 for details.

This bug is proved to be in the following Sybase provider version: 1.15.152.0.

Resolution
Use OleDb Sybase provider or install ADO.NET Data Provider of version 1.15.50.

More Information
Article Id: KBS2SS1003

Applies to
• SSMA 2005 for Sybase
• SSMA 2008 for Sybase