Home » RDBMS Server » Server Administration » tools to differentiate two database schemas?
tools to differentiate two database schemas? [message #215378] Sun, 21 January 2007 22:51 Go to next message
karismapanda
Messages: 58
Registered: January 2007
Member
Hi All,

I have various schemas in my database.I want to differentiate any two schemas to get object differences,column differences,data type differences.......
Is there any tool in oracle or any third party tool available to solve my problem?

Anybody please suggest.

Thanks,
Karisma
Re: tools to differentiate two database schemas? [message #215379 is a reply to message #215378] Sun, 21 January 2007 23:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
http://www.dbsolo.com/schema_comparison.html

Go through above link hope this helps
Taj
Re: tools to differentiate two database schemas? [message #215385 is a reply to message #215379] Sun, 21 January 2007 23:46 Go to previous messageGo to next message
karismapanda
Messages: 58
Registered: January 2007
Member
Hi,
Thanks a lot.this tool is really helpful.
Karisma
Re: tools to differentiate two database schemas? [message #215403 is a reply to message #215385] Mon, 22 January 2007 02:53 Go to previous messageGo to next message
cbruhn2
Messages: 41
Registered: January 2007
Member
You may also be interested in checking out
http://www.codeproject.com/vb/net/OracleSchemaCompare.asp
I find this tools useful.

best regards
Re: tools to differentiate two database schemas? [message #215487 is a reply to message #215378] Mon, 22 January 2007 08:46 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
I think the DBA module of TOAD has a schema compare tool, which if I recall, was pretty good.
Re: tools to differentiate two database schemas? [message #215493 is a reply to message #215378] Mon, 22 January 2007 09:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Just to add another option to the stack, Oracle's OEM offers Change Manager (if you are licensed for it).
Re: tools to differentiate two database schemas? [message #226893 is a reply to message #215378] Mon, 26 March 2007 19:46 Go to previous messageGo to next message
rbedick
Messages: 2
Registered: March 2007
Junior Member
You might want to consider DB Side-By-Side (http://www.schematodoc.com). It lets you create xml snapshots of a database's metadata. You can then compare any two snapshots to identify differences in primary keys, fields (datatype, size, nullable, defaults), indexes, check constraints, foreign keys, triggers, views and stored procedures. You can compare two different databases or the same database at two different points in time.
Re: tools to differentiate two database schemas? [message #228290 is a reply to message #215378] Mon, 02 April 2007 07:53 Go to previous messageGo to next message
joesix
Messages: 2
Registered: April 2007
Junior Member
BTW, the latest version of DB Solo - SQL Query Tool can also create schema synchronization scripts and
the comparisons can be run from command line.

MH
Re: tools to differentiate two database schemas? [message #285125 is a reply to message #228290] Mon, 03 December 2007 11:54 Go to previous message
MikeSanders
Messages: 6
Registered: December 2007
Junior Member
For data comparison, I am using a tool called Comparenicus.
http://www.comparenicus.com

You can compare and sync data between two databases.
You can also, copy an object graph from one DB to another.

Very neat and professional.
Previous Topic: Alert_Log
Next Topic: Requirements in changing the sys password.
Goto Forum:
  


Current Time: Sat Dec 10 11:00:01 CST 2016

Total time taken to generate the page: 0.04136 seconds