Re: upgrading a schema

From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 18 Sep 2006 22:31:56 +0200
Message-ID: <450f023c$0$28387$ba620e4c@news.skynet.be>

<timasmith_at_hotmail.com> wrote in message news:1158610383.787629.96560_at_k70g2000cwa.googlegroups.com...
> Hi,
>
> I have an application using Oracle with a large (100+) number of
> tables. Are there any free/open source tools that can ease the process
> of updating the schema.
>
> Specifically I would like to compare a source and a target, determine
> the differences and the best way to update the target to be equivalent
> to the source - tables, columns, views, etc.
>
> thanks
>

You can do that with third-party tools like TOAD - it can even generate a script with the differences. Maybe you can do it with Oracle's free SQL Developer, don't know about that. I believe Enteprise Manager with the Change packs can also do it.

Matthias Received on Mon Sep 18 2006 - 15:31:56 CDT