Re: comparing two databases on two different servers?

Check out Quest software's Schema manager product. Embarcadero software also has a product to do this. We use DBArtisan for sybase, oracle, db2, and (don't laugh) but we have occasion to do some Microsoft sql work...... (I'm so ashamed)

Quest allows you to compare to schemas and even version them. It's feature for comparing packages and procedures is very nice. I little cumbersome, but much much much much better than diffing to extracts. We have done both ;-) Just playing around with Embarcadero's product. Looks good also.

Doug Coan
Senior Client Server Systems Integrator DCoan_at_aegonusa.com
"Live to Learn and Learn to Live"

On Fri, 13 Aug 1999 21:29:19 -0700, David Spaisman <davedba_at_intercall.net> wrote:

>Hello:
>
>I have a developer who has been running two different databases (oracle
>8.0.4 on NT) on two different servers.
>I think I could use erwin to compare the two by reverse engineering an
>hen running a comapre between the two outputs. This is rather
>cumbersome.
>
>Does any one know of nay other way to comparetwo different databases on
>two different servers to see differents in table structures, views etc?
>
>Thanks.
>
>David Spaisman
>

Doug Coan
Senior Client Server Systems Integrator DCoan_at_aegonusa.com
"Live to Learn and Learn to Live" Received on Sun Aug 15 1999 - 11:52:53 CDT