Re: For Schema Comparision Experts

From: bernard (bernard_at_bosvark.com) <bernard_at_bosvark.com>
Date: 9 Oct 2006 02:41:08 -0700
Message-ID: <1160386868.735050.213490@m7g2000cwm.googlegroups.com>

> I have a task that needs me to compare two different schemas in two
> different databases.
>
> My issue is with connectivity. How do I use the information about the
> second database (ie the database Im not using currently).

I'm sure you can resolve this using PL/SQL and database links but for ease of use I use a tool called PL/SQL Developer to compare schemas in different databases. It connects to both databases and generates SQL between target and source that can be applied to the target to get it in sync with the source. Note: this only applies to data structures and not data, although PL/SQL developer also has a data sync tool too. Received on Mon Oct 09 2006 - 04:41:08 CDT