Re: How to compare DB Tables in different Instances - MORE OPTIONS

Paul Chu wrote:
> I'm really looking for a convenient way to compare the Schema of two DB instances
> to insure that we detect any DB changes between an In-house Development DB and a
> Client Version (deployed version) of the same DB. We would like a way to
> compare by connecting to both DBs.

Try TOAD : http://www.toadsoft.com/

If is a free tool that is similar i functionality to SQL Navigator and such tools. It has an option to compare two schemas. It is only a 1Mb download, and once you have it you'll want to keep it :)

Look under View->Schema Differences
You'll need an appropriate db_link to do it however.

Haakon

--
Core Technology AS
Oslo, Norway