Migration tool
From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com.invalid>
Date: Mon, 21 Dec 2009 16:36:35 +0100
Message-ID: <hgo4m5$69g$1_at_news.eternal-september.org>
[Quoted] [Quoted] 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.
Date: Mon, 21 Dec 2009 16:36:35 +0100
Message-ID: <hgo4m5$69g$1_at_news.eternal-september.org>
[Quoted] [Quoted] 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 :(
--
- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
- Mi sitio sobre programación web: http://borrame.com
- Mi web de humor satinado: http://www.demogracia.com --