Re: Migration tool

From: Shakespeare <>
Date: Mon, 18 Jan 2010 09:28:45 +0100
Message-ID: <4b541bc2$0$22942$>

Op 21-12-2009 16:36, "Álvaro G. Vicario" schreef:
> 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.
> I work on Windows but Linux tools are welcome too. The server is a local
> install of Oracle 10g XE but the script is supposed to run in whatever
> Oracle the customer has purchased. Thank you in advance.
> P.S. I've found several shareware utilities but I have no budget :(

If you have an Oracle Developer Suite license, you can use Oracle Designer to do this. But the "no budget" remark makes me think you don't....

Shakespeare Received on Mon Jan 18 2010 - 09:28:45 CET

Original text of this message