View Single Post

   
  #2 (permalink)  
Old 02-25-2008, 07:41 AM
bernard (bernard_at_bosvark.com)
 
Posts: n/a
Default Re: For Schema Comparision Experts


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

Reply With Quote