Getting errot"Could not count rows in the target table after migration. Migration may have succeeded, but row count is not verified."
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
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.