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

On 18 Feb 2005 13:40:20 -0800, "deanbrown3d_at_yahoo.com" <deanbrown3d_at_yahoo.com> wrote:

>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

The best way to deal with this is to have a proper development process in place, source code control, and a beating for those people who continue to change the database on the fly.

--
Sybrand Bakker, Senior Oracle DBA