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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,788 questions
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.
532 questions
0 comments No comments
{count} votes

Your answer

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