Monday, August 3, 2009

Data Migration reports migration for each row in table

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 for details.

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

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

No comments:

Post a Comment