| How to verify migrated data [message #326704] |
Thu, 12 June 2008 05:57  |
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
|
Member |
|
|
Hi all - Could not find data migration section so posting here....
I require to verify migrated data.
Source database - Oracle 9i R2
Destination database - Oracle 9i R2 (same)
Some of the composite primary keys from source schema have been merged into single primary key in destination schema.
Similarly there are other columns that have been merged into single column in new schema.
Oracle data migration verifier supports Sql Server and Sybase as source database.
Is there any other tool available that can verify the migrated data?
Thanks in adv.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to verify migrated data [message #326764 is a reply to message #326704] |
Thu, 12 June 2008 09:19  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Is there any other tool available that can verify the migrated data?
In my opinion this request is rather vague.
What is the criteria which needs to be met to conclude the data is OK or not?
Is it sufficient that the row counts in the corresponding tables are the same values?
What has to occur for a discrepancy to be reported?
[Updated on: Thu, 12 June 2008 09:27] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: How to verify migrated data [message #326768 is a reply to message #326704] |
Thu, 12 June 2008 09:28 |
|
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
Does every table have a Primary Key?
If not, how do you detect & report "missing" data?
In my opinion, no generalized package will know about composite columns so, you will need to write your comparer package.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
