RE: Database analysis

Hi Shirley,

I saw a similar question in a russian oracle forum last week. The answers are below:

1. Change Management Pack from Oracle Enterprise Manager (Oracle)
2. ERwin (Platinum)
3. Schange Manager (Embarcadero) <= can compare schemas between 2 db's only

I'm not sure these products compare data (number of rows, etc)

HTH Ed

>
> We're looking for software which will help us to compare the
> state of all
> database objects before and after full export. We want to be
> able to run a
> program to gather info on schemas and objects that can then
> be used in
> automated validation routines after backup restorations and
> imports, for
> example: total count of tables by schema and row counts,
> status of indices,
> views, procedures, etc., current/next sequence value, etc.
> Ideally, we'd
> like to get a snapshot of the whole database before and
> after and produce a
> report to pinpoint differences. Any ideas?
>
> Thanks,
> Shirley
> Systems Admin & Operations | Admin. et Expoit. des syst?ms
> Technology Services | Services technologiques
> Informatics Branch | Direction de l'informatique
> Maritimes Region, DFO | R?gion des Maritimes, MPO
> St. Andrews, N.B., Canada
> ph: (506)529-5911
> fax:(506)529-5862
> taylorsi_at_mar.dfo-mpo.gc.ca
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Taylor, Shirley
> INET: TaylorSI_at_mar.dfo-mpo.gc.ca
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Nov 28 2000 - 08:58:30 CST