Re: Migration tool

From: Mark D Powell <>
Date: Mon, 21 Dec 2009 13:27:20 -0800 (PST)
Message-ID: <>

[Quoted] On Dec 21, 2:09 pm, "Gerard H. Pille" <> wrote:
> "Įlvaro G. Vicario" wrote:
> > I have two file trees that correspond to two differerent versions of the
> > database schema for a web application I'm developing. These files
> > contain the SQL code to generate the objects (tables, sequences,
> > views...). I can find out what changed with any standard compare tool (I
> > use WinMerge). But it's hard to obtain a script with the appropriate
> > ALTER TABLE commands to migrate a live DB from one version to another.
> > Is there any free or open source tool I could use? I don't need it to
> > have fancy graphics or make everything for me; any improvement over
> > writing it all from scratch will be welcome. I'm interested in DB
> > structure, not data.
> Tora?

As in

Per the site as I have no experience with this tool:

TOra is a Toolkit for Oracle which aims to help the DBA or developer of database applications. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a full set of DBA tools. TOra also includes support for MySQL and Postgres.

HTH -- Mark D Powell -- Received on Mon Dec 21 2009 - 22:27:20 CET

Original text of this message