| Schema Comparing tool [message #550268] |
Sun, 08 April 2012 00:42  |
|
|
|
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 #550299 is a reply to message #550298] |
Sun, 08 April 2012 03:05  |
John Watson
Messages: 8964
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 #550943 is a reply to message #550466] |
Fri, 13 April 2012 13:51 |
|
|
LKBrwn_DBA wrote on Mon, 09 April 2012 13:39arif_md2009 wrote on Sun, 08 April 2012 01:42Hi , 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
