OraFAQ Forum: Server Administration » tools to differentiate two database schemas?

Home » RDBMS Server » Server Administration » tools to differentiate two database schemas?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tools to differentiate two database schemas? [message #215378]

Sun, 21 January 2007 22:51

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

Report message to a moderator

Re: tools to differentiate two database schemas? [message #215379 is a reply to message #215378]

Sun, 21 January 2007 23:11

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

Report message to a moderator

Re: tools to differentiate two database schemas? [message #215385 is a reply to message #215379]

Sun, 21 January 2007 23:46

karismapanda
Messages: 58
Registered: January 2007

Member

Hi,
Thanks a lot.this tool is really helpful.
Karisma

Report message to a moderator

Re: tools to differentiate two database schemas? [message #215403 is a reply to message #215385]

Mon, 22 January 2007 02:53

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

Report message to a moderator

Re: tools to differentiate two database schemas? [message #215487 is a reply to message #215378]

Mon, 22 January 2007 08:46

joy_division
Messages: 4963
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.

Report message to a moderator

Re: tools to differentiate two database schemas? [message #215493 is a reply to message #215378]

Mon, 22 January 2007 09:27

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).

Report message to a moderator

Re: tools to differentiate two database schemas? [message #226893 is a reply to message #215378]

Mon, 26 March 2007 19:46

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.

Report message to a moderator

Re: tools to differentiate two database schemas? [message #228290 is a reply to message #215378]

Mon, 02 April 2007 07:53

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

Report message to a moderator

Re: tools to differentiate two database schemas? [message #285125 is a reply to message #228290]

Mon, 03 December 2007 11:54

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.

Report message to a moderator

Previous Topic:	Alert_Log
Next Topic:	Requirements in changing the sys password.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:21:11 CDT 2024