Migration tool
"Álvaro G. Vicario"
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
--
Gerard H. Pille
> 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?
Mark D Powell
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 --
"Álvaro G. Vicario"
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).
Mark D Powell
<alvaro.NOSPAMTH...@demogracia.com.invalid> wrote:
> El 21/12/2009 22:27, Mark D Powell escribió:
>
>
>
>
>
> > On Dec 21, 2:09 pm, "Gerard H. Pille"<g...@skynet.be> 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?
>
>
> > 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.
>
> 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).
>
> --
> -- Mi sitio sobre programación web:http://borrame.com> --- Hide quoted text -
>
> - Show quoted text -
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.
Gerard H. Pille
>
> 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).
>
>
>
I use it daily, iso Toad. But I checked that part today, and indeed, it isn't finished.
Well, you didn't lose a lot of money, unless you're an american immigrant.
"Álvaro G. Vicario"
>> 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).
>>
>>
>>
>
> I use it daily, iso Toad. But I checked that part today, and indeed, it
> isn't finished.
Alright... You always wonder whether you're doing something wrong...
I've just noticed that the 2.0.0 version is one year old and there're
two newer releases in the Files section in SourceForge. However, there
aren't binaries for Windows.
> Well, you didn't lose a lot of money, unless you're an american immigrant.
I don't get it, but it's probably because I'm neither American nor
immigrant...
dvdtknsn
> 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.
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/schema_compare_for_oracle/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
Shakespeare
> 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
"Álvaro G. Vicario"
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 :-?
dvdtknsn
<alvaro.NOSPAMTH...@demogracia.com.invalid> wrote:
> El 17/01/2010 19:40, dvdtknsn escribi :
>
> >> 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.
>
> > 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/schema_compare_for_oracle/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.
>
> 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 :-?
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/viewforum.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