Home » RDBMS Server » Server Administration » Schema comparision---Info needed
Schema comparision---Info needed [message #132167] Thu, 11 August 2005 03:47 Go to next message
ankurgodambe
Messages: 45
Registered: March 2005
Member
Hi,

I need some information regarding comparing schemas in database. Is there any tool available which can help me compare two schemas not just at the structural level but also the data. I am aware of toad and DBdiff but just wanted to know if anyone is using a better tool. The tool should be able to compare the data in the two schemas and also generate scripts to insert, update or delete data in order to sync the data. TOAD does the comparision at object level but not the data. Please let me know if there is any such tool..

Thanks in advance....
Ankur

Report message to a moderator

Re: Schema comparision---Info needed [message #132873 is a reply to message #132167] Tue, 16 August 2005 08:45 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
You can easily create your own. Read this article for details - http://www.orafaq.com/articles/archives/000065.htm:

"In this article James continues to explore the Oracle's Metadata API and provides a powerful function to compare objects and schemas and print the DDL required to bring them in sync."

Best regards.

Frank

Report message to a moderator

Re: Schema comparision---Info needed [message #132937 is a reply to message #132167] Tue, 16 August 2005 22:43 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
You can also use toad to compare the schema objects.

Under menu DBA-> Compare schemas.

-Sai Jeedigunta

Report message to a moderator

Previous Topic: Table hang
Next Topic: How to Make two Databases Equal...Some body help me
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 10:37:19 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.