Re: comparing two databases on two different servers?

You can use SQLEXP to do the same.
see http://www.wxs.nl/~erwindon/oratools.html

Then run:

sqlexp -l account/password_at_database1 -r account > x sqlexp -l account/password_at_database2 -r account > y diff x y

    Erwin

David Van Zandt wrote:

> ERWin 3.x has the capability to generate a database build script. Save
> the output SQL from both SIDS, then run them through a file comparison
> utility. Viewdiff, for example, is bundled with NetManage.
>
> HTH,
> Dave
>
> David Spaisman 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

--
Erwin Dondorp
<http://www.wxs.nl/~erwindon> Received on Sun Aug 15 1999 - 16:09:46 CDT