RE: Database Comparison

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 09 Jan 2002 11:01:02 -0800
Message-ID: <F001.003EB429.20020109103525@fatcity.com>

Srini

I agree with James. Free tool does a pretty good job. I question it's report of db triggers and views, though. Doesn't seem to be right - it always reports them out of sync for me.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, January 09, 2002 12:35 PM To: Multiple recipients of list ORACLE-L

Srini,

I would suggest going to http://www.toadsoft.com and downloading the freeware version in order to use the "Schema Compare" tool. All it would require would be a database link between your Production DB and your QA DB, or vice-versa. It will show you all object differences.

Jim

---

Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri 63167

Work          (314) 694-4417
Cellular     (314) 724-9664
Pager         (314) 294-9797

james.w.hawkins_at_pharmacia.com

-----Original Message-----
Sent: Wednesday, January 09, 2002 9:50 AM To: Multiple recipients of list ORACLE-L

Hi:

I need to compare my Production database with QA database. I would like to generate a report that shows differences in schemas across these two databases(tables, indexes, views, object definition, etc..). I would appreciate it if you could forward me a script that would accomplish this or any websites where I can find one.

Thanks

Srini Rajendran.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: SRAJENDRAN_at_nlfs.com

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: HAWKINS, JAMES W [IT/1000]
  INET: james.w.hawkins_at_pharmacia.com

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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 Wed Jan 09 2002 - 13:01:02 CST