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
--

"Álvaro G. Vicario" wrote:
Tora?

On Dec 21, 2:09*pm, "Gerard H. Pille" <g... (AT) skynet (DOT) be> wrote:
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 --

El 21/12/2009 22:27, Mark D Powell escribió:
Nice suggestion, I hadn't heard of this program. It has a tool called
"DB Extraction/Compare/Search" that _seems_ to be able to do what I need
(although I've spent like an hour trying to figure out how to do it,
with no luck).



--
-- 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
--

On Dec 22, 5:10*am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH... (AT) demogracia (DOT) com.invalid> wrote:
Helpfully you will figure it out. As I said I have never used the
product and did not know of it till I read this thread. Just keep in
mind that while the tool may generate the commands to make two tables
look alike it will not be able to determine the sequence of events
that resulted in the current state.

That is while the code might generate an add column command to add a
new column and a drop column command to eliminate one no longer
present it will not know the actual sequence of events was to add the
new column, to update it with the data from another column, and then
to drop that other column, which can be done via a column rename
command now, but was done as described above in the past.

That is I am suggesting a manual review of the differences and the
effect of the changes applying the changes.

HTH -- Mark D Powell --

Hi there,
Although it's won't be free when it is released, Schema Compare for
Oracle is currently free to use during its pre-release period, which
is now. You can download the latest build from the link below:

http://www.red-gate.com/Products/sch...acle/index.htm

Bear in mind that this is early access software, so please understand
that there may be bugs. Of course we'd be very interested if you would
give us your feedback if you choose to trial the tool.

Kind regards,

David Atkinson, Product Manager, Red Gate Software

Op 21-12-2009 16:36, "Álvaro G. Vicario" schreef:
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

El 17/01/2010 19:40, dvdtknsn escribió:
Will I be able to use my early access installation then the final
version is released? I'm not very fond of using tools with expiration
date...

Whatever, the software looks promising although it considers that *all*
the objects have changed if they are identical but belong to different
databases. I guess two servers are required :-?



--
-- 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
--

On Jan 18, 10:24*am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH... (AT) demogracia (DOT) com.invalid> wrote:
All early access builds are time-bombed as we want to avoid situations
where users are reporting in problems with 'out of date' builds.
However, as the product won't be available until Q2 this year, it will
give you a few months of free usage, although you'll need to update to
newer builds as they come out. Beyond that to carry on using the tool
you would have to go down the path of requestiong trial extension
serial numbers.

With regards to your objects being changed, I'm guessing that you mean
within the stored procedures, your objects are listed as different
because different schemas are referenced? If so, we're currently
adding an option to fix this and remove these 'false positives'. If
this isn't the issue would you be able to describe this issue in more
detail on: http://www.red-gate.com/MessageBoard...orum.php?f=112
and the project team will respond to you directly? All feedback is
tremendously useful and should ensure the product meets your
requirements as much as possible.

Thanks and regards,

David