Re: Oracle schema comparison

Hi,

Look into Toad by quest software.  It has a schema comparison tool.

Regards,
Michael

Date: Thu, 16 Jun 2005 11:11:12 -0400
From: Steve Sapovits <steves06@xxxxxxxxxxx>
To: dbi-users@xxxxxxxx
Subject: Oracle schema comparison


Does anybody know of any good tools (free or otherwise) for comparing
two Oracle schemas?  I'd want to be able to compare tables, indices,
sequences, etc. to see what one has and another doesn't.  In an ideal
world I'd also be able to compare the actual data in the tables, but
the primary need is to be able to see if tables and indices match.



---//---
"He who learns must suffer. And even in our sleep,
pain that cannot forget, falls drop by drop upon the heart; and, in our own despair, against our will,
comes wisdom to us by the awful grace of God."
--- Aeschylus
.

Relevant Pages

  • Re: Segmented Binary Diff
    ... > If any matching of sequences would break stuff, ... If you compare pairwise first then I think you will indeed have to throw ... Iterate over all of the edit scripts simultaniously ... The trick is to make sure you compare offsets corresponding to the same ...
    (comp.programming)
  • Re: "t" stands for the type true and for the boolean expression true ..
    ... >> I am hardly an expert, but the 'obvious solution' to me is to store it ... In the event you had to compare two such sequences you ... > The comparisons involved are rarely base by base. ...
    (comp.lang.lisp)
  • Re: abundance of irrationals
    ... >> If you compare ... > partitioning of the rationals or a collection of infinite ... > sequences of rationals (Cauchy sequences whose differences are null ... > Given either the partition form or the family of sequences form, ...
    (sci.math)
  • Re: "t" stands for the type true and for the boolean expression true ..
    ... DR> use characters rather than symbols, and they store large ... Now to compare large sequences you can use integer comparison. ... having to load large chunks of data from disk during a compare or simular operation. ...
    (comp.lang.lisp)
  • Re: print values out of a hash - filling the hash
    ... > I want to compare two fasta-files, more precisely the IDs of two sets ... Here you seem to say that you want to compare the sequences and not the ... If you want to associate all sequences with their corresponding IDs then ...
    (perl.beginners)