Re: Migration tool

[Quoted] On Dec 21, 2:09�pm, "Gerard H. Pille" <g..._at_skynet.be> 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 http://sourceforge.net/projects/tora/

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