Q:
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
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
ASKED:
Nov 24 2009 4:35 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
