Getting errot"Could not count rows in the target table after migration. Migration may have succeeded, but row count is not verified."

M M 10 Reputation points
2023-09-21T00:56:14.0233333+00:00

I use ssma for oracle application to migrate a big table(over 46M rows)from oracle database to sqlserver (sql server management studio).

I followed these steps :

1.When I connect to sqlserver ,I change the target database name instead of the default database name.

2.Convert Schema (ORACLE Metadata explorer)

3.Before migrate data ,I changed migration setting of project settings

  • Data migrtation time to 600图片_20230921095240

After this when I tried to Migrate Data , I got the error message :

Could not count rows in the target table after migration. Migration may have succeeded, but row count is not verified.

Please help me ,thank you very much.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
SQL Server | Other
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.