Home » SQL & PL/SQL » Client Tools » How to verify migrated data (Oracle DB 9i R2, Unix)
How to verify migrated data [message #326704] Thu, 12 June 2008 05:57 Go to next message
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 #326741 is a reply to message #326704] Thu, 12 June 2008 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OP asked to remove this topic in reported message.

I have a question: why do you want to remove it?

Regards
Michel
Re: How to verify migrated data [message #326746 is a reply to message #326741] Thu, 12 June 2008 08:37 Go to previous messageGo to next message
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

I would like to take this post to different category

Regards,
Re: How to verify migrated data [message #326750 is a reply to message #326746] Thu, 12 June 2008 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can to move it in other forum.
Which one do you think it is better?

Regards
Michel
Re: How to verify migrated data [message #326751 is a reply to message #326750] Thu, 12 June 2008 08:44 Go to previous messageGo to next message
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

SQL and PL/SQL. There this post might get some attention.

Regards,
Re: How to verify migrated data [message #326752 is a reply to message #326751] Thu, 12 June 2008 08:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe Client Tools is a more appropriate one.
I don't think SQL & PL/SQL is a good one for your question:
Quote:
Is there any other tool available that can verify the migrated data?

Regards
Michel
Re: How to verify migrated data [message #326757 is a reply to message #326752] Thu, 12 June 2008 09:05 Go to previous messageGo to next message
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

I do not think here I'll get replies anytime soon........

Thanks anyway.

Regards,
Re: How to verify migrated data [message #326764 is a reply to message #326704] Thu, 12 June 2008 09:19 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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 #326767 is a reply to message #326764] Thu, 12 June 2008 09:25 Go to previous messageGo to next message
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

Well, it would not be only about count of rows but also the data in columns.

I should be able to check that all data in two tables are exactly same.

It would be good if I can map composite columns to merged single column and compare.

Verifying data only (that they are exactly same in the two schema) would do.

Regards,
Re: How to verify migrated data [message #326768 is a reply to message #326704] Thu, 12 June 2008 09:28 Go to previous message
BlackSwan
Messages: 25035
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.
Previous Topic: Viewing stored proc code
Next Topic: running web in form6i
Goto Forum:
  


Current Time: Sat Dec 03 20:07:45 CST 2016

Total time taken to generate the page: 0.08813 seconds