Whats the best way to see what changes have been made to a database structure?

Hi there,

Our small company regularly alters tables, creates new views, adds triggers and sequences, and these changes have to be reciprocated at out (single) client site. Its hard to keep track, as people forget the changes they have made, or don't bother to update files of changes.

What's the best way to compare 2 different schemas in a single database? Something that will tell me things like:

1. This table T1 has a new fields...
2. This table T2 does not exist...
3. This table T3 has a different key...
4. This view is different.
5. This trigger is changed.
6. This sequence is new. etc....

Thanks for any help,

Dean Received on Fri Feb 18 2005 - 15:40:20 CST