king87501 king87501 - 1 year ago 50
SQL Question

Rows counts are not matching after migration from Oracle to SQL Server

I migrated database from oracle to Sql server using sqlmigration(SSMA) tool.
After migration, report say 100% successfully migrated but the row counts are more than oracle in Sql Server. I cant figure out why its showing more row counts than oracle. Please Help

Answer Source

perform row count like ->

-- Source

select count(1) from table_source; 

-- Target

select count(1) from table_target;