How do I confirm all the data moved from Source to target for different tables
How do I confirm all the data moved from Source to target for different tables.
I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate.
Thanks
Software/Hardware used:
SQL
Software/Hardware used:
SQL
ASKED:
November 24, 2009 4:35 PM
UPDATED:
November 25, 2009 11:26 PM
Answer Wiki:
With SQL. use the
Select COUNT(*)
option for each of the tables in both the source and target system.
That will tell you if your record count is correct.
*
If you want to get to the record level, you can do a EXCEPTION JOIN
----------------- kccrosser
I commonly check two tables using either EXCEPT (SQL Server) or MINUS (Oracle):
select * from <table1>
except
select * from <table2>
This will return all rows in table1 that are not in table 2. Obviously, running it in reverse verifies there are no extra rows in table 2:
select * from <table2>
except
select * from <table1>
In Oracle, the "MINUS" term has the same effect.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
