Title: script for comparing two schemas in two databases
Hi!
Does anybody out there have a script that allows me to compare two schemas in two different databases (i.e. development and production db)?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
two
schemas in two databases
[EMAIL PROTECTED
Attached..
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===
Hi!
Does anybody out there have a script that allows me
to compare two schemas
in two different databases (i.e. development and
production db)?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
There's something in the DBA tool kit at http://www.oriole.com. Forgot the exact name.
Regards,
Title: script for comparing two schemas in two databases
Hi Helmut,
There are some tools for it. For example, Oracle
Change Manager Pack for OEM.
This is a tough task for script, because too many
factors are involved.
HTH,
Alexandre
- Original Message -
From:
Daiminger
Thanks for the script Mark!
Dave
-Original Message-
Sent: Wednesday, May 29, 2002 4:53 AM
To: Multiple recipients of list ORACLE-L
Attached..
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F:
OEM's Change Management pack does just that. It also allows you to
compare it with previous snapshots and implement them into production in
a scheduled, controlled manner.
Regards,
Michael Sale
Co-author: Oracle 9i on Windows 2000 Tips and Techniques
-Original Message-
Helmut
Sent:
Title: script for comparing two schemas in two databases
Years
ago, I found a script on Metalink that worked decently after a few bug
fixes. It was written by Ottar Sorland for use withOracle 7.3.
I still occasionally use it and cansend my patched (but still not perfect)
version if youneed
The Oracle Enterprise Manager 'Change Manager' does a good job of schema
comparisons, and has an easy point-and-click interface that shields you from
having to know what you're doing ;-)
The downside is that it can be a pain to get oem set up and working. I've never
tried it's more advanced
Kevin,
You should download the ver 7.3 of TOAD. It has a lot of improvements
that You might find handy.
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 05/29/02 01:24PM
Years ago, I found a script on Metalink that worked decently after a
few bug fixes. It was written by Ottar Sorland for use with Oracle
I came to that conclusion as well. I especially like the fact that it even
creates a sync script after the compare.
I just used it on two of our DBs. Worked great.
-Original Message-
Sent: Wednesday, May 29, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Kevin,
You should
11 matches
Mail list logo