 | |
Comparing databases (Oracle, etc.)
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Comparing databases (Oracle, etc.) -
04-02-2008
, 12:25 PM
|
AgataKrishtoff wrote: Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata The capability is built into the database. In versions prior to 11g use DBMS_RECTIFIER_DIFF In 11g use DBMS_COMPARISON -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
#12
| |||
| |||
|
|
AgataKrishtoff wrote: Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata The capability is built into the database. In versions prior to 11g use DBMS_RECTIFIER_DIFF In 11g use DBMS_COMPARISON -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
#13
| |||
| |||
|
|
AgataKrishtoff wrote: Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata The capability is built into the database. In versions prior to 11g use DBMS_RECTIFIER_DIFF In 11g use DBMS_COMPARISON -- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
#14
| |||
| |||
|
|
On Apr 1, 6:59 pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote: Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata I once wrote a routine to compare the contents of a table loaded with the contents of dba_tab_columns from multiple databases. You could do the same. Tom Kyte has written about comparing tables to find differences so you can probably find an article on this athttp://asktom.oracle.comvia the search feature there. select * from tableA minus select * from TableA@databaseB HTH -- Mark D Powell -- |
everyone else but me knows it
). Thank you for the ref!
#15
| |||
| |||
|
|
On Apr 1, 6:59 pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote: Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata I once wrote a routine to compare the contents of a table loaded with the contents of dba_tab_columns from multiple databases. You could do the same. Tom Kyte has written about comparing tables to find differences so you can probably find an article on this athttp://asktom.oracle.comvia the search feature there. select * from tableA minus select * from TableA@databaseB HTH -- Mark D Powell -- |
everyone else but me knows it
). Thank you for the ref!
#16
| |||
| |||
|
|
On Apr 1, 6:59 pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote: Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata I once wrote a routine to compare the contents of a table loaded with the contents of dba_tab_columns from multiple databases. You could do the same. Tom Kyte has written about comparing tables to find differences so you can probably find an article on this athttp://asktom.oracle.comvia the search feature there. select * from tableA minus select * from TableA@databaseB HTH -- Mark D Powell -- |
everyone else but me knows it
). Thank you for the ref!
#17
| |||
| |||
|
|
On Apr 1, 6:59 pm, AgataKrishtoff <agata0krisht... (AT) gmail (DOT) com> wrote: Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata I once wrote a routine to compare the contents of a table loaded with the contents of dba_tab_columns from multiple databases. You could do the same. Tom Kyte has written about comparing tables to find differences so you can probably find an article on this athttp://asktom.oracle.comvia the search feature there. select * from tableA minus select * from TableA@databaseB HTH -- Mark D Powell -- |
everyone else but me knows it
). Thank you for the ref! |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.