During data migration of even very big tables, SSMA reports migration of each single data row. This slows down data migration.
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: 18.104.22.168.
Use OleDb Sybase provider or install ADO.NET Data Provider of version 1.15.50.
Article Id: KBS2SS1003
• SSMA 2005 for Sybase
• SSMA 2008 for Sybase