Home » RDBMS Server » Server Administration » Schema Comparing tool (Oracle 10.1.0.2)
Schema Comparing tool [message #550268] Sun, 08 April 2012 00:42 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Hi , we have a two different databases at different locations and on different servers, like one in our company with SID='A' and remote database with SID='B', We have recently implemented new module in database 'A' by creating lots of tables,functions,indexes,sequences,synonymns etc and now we need to install this on 'B' but the problem is we have not documented which tables we created, first we need to create a DB link between these two and then we need a tool to compare what are all the tables that we need to creat in database 'B' , is there a tool for doing all this.
Re: Schema Comparing tool [message #550271 is a reply to message #550268] Sun, 08 April 2012 00:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>is there a tool for doing all this.
sqlplus
Re: Schema Comparing tool [message #550285 is a reply to message #550268] Sun, 08 April 2012 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but the problem is we have not documented which tables we created


You should FIRST fix this and maybe the creation date of the objects will help to do so.

Regards
Michel
Re: Schema Comparing tool [message #550298 is a reply to message #550285] Sun, 08 April 2012 02:57 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks michael , but i feel there should be some tool to do this comparision like difference between schemas, objects available in A not in B and viceversa.
Re: Schema Comparing tool [message #550299 is a reply to message #550298] Sun, 08 April 2012 03:05 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
i feel there should be some tool to do this comparision like difference between schemas, objects available in A not in B
Why don't you write your own tool to do this, present it at Open World and be famous? You could begn with somthing like this:
select object_name,object_type from dba_objects@db1 where owner='SCOTT'
minus
select object_name,object_type from dba_objects@db2 where owner='ARIF';
Re: Schema Comparing tool [message #550466 is a reply to message #550268] Mon, 09 April 2012 12:39 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
arif_md2009 wrote on Sun, 08 April 2012 01:42
Hi , we
... Etc ...
need a tool to compare what are all the tables ... Etc ...


Perhaps you could use the "Database Differences" functionality provided by SQL Developer.

[Updated on: Mon, 09 April 2012 13:49] by Moderator

Report message to a moderator

Re: Schema Comparing tool [message #550571 is a reply to message #550268] Tue, 10 April 2012 08:06 Go to previous messageGo to next message
marcossantos
Messages: 123
Registered: June 2008
Senior Member
SQuirreL SQL is very good.
Re: Schema Comparing tool [message #550943 is a reply to message #550466] Fri, 13 April 2012 13:51 Go to previous message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

LKBrwn_DBA wrote on Mon, 09 April 2012 13:39
arif_md2009 wrote on Sun, 08 April 2012 01:42
Hi , we
... Etc ...
need a tool to compare what are all the tables ... Etc ...


Perhaps you could use the "Database Differences" functionality provided by SQL Developer.


I think that require licensing of the Oracle Management Packs. The same like for OEM, you have to access Change Manager tool and compare database objects.

Another way would be a third party tool like Red Gate or Toad. You can try out a free 30-day trial version. But I agree with John Watson that scripting is the best option. You may find this thread interesting.

[Updated on: Fri, 13 April 2012 13:58]

Report message to a moderator

Previous Topic: Oracle DB Server Migration Checklist
Next Topic: SGA memory filled
Goto Forum:
  


Current Time: Fri Mar 29 10:09:38 CDT 2024