Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tool for compare/upgrade different schemas

Re: Tool for compare/upgrade different schemas

From: Fred Pierce <lists_at_avialantic.com>
Date: Thu, 12 Jan 2006 09:41:27 -0500
Message-ID: <3eqcs19v80hfeo20auiuq2e1r447umieti@4ax.com>


On 9 Jan 2006 06:39:09 -0800, "swetly" <svetoslavd_at_gmail.com> wrote:

>Hi,
>
>Does anyone knows a tool which can easily compare different schemas and
>to generate DDL for the differences? As well to compare the data in the
>tables.
>
>Thank you
>Svetoslav

Oracle's Change Manager does it - repository based too. As someone else mentioned, PLSql Developer has a compare feature, and is pretty low cost. Not sure about data comparison though - IIRC developer does a row count comparison.

fdp

Fred Pierce - Avialantic.com Received on Thu Jan 12 2006 - 08:41:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US