Hi there,
A couple of weeks ago I sent out a request for help with updating ORACLE
databases with changes that have been made to Progress databases. I did not
receive very much in the way of replies, so I am trying again. There must be
someone out there who is working with or has worked with a doable solution
for UPDATING oracle databases instead of having to create new databases
every time If there are - HELP )
The situation is as follows :
We are using Progress 8.3B (AIX server and NT clients).
I have just set up a system where our customer is going to be making their
primary database development against Progress databases instead of ORACLE
databases. There are a number of reasons for doing this, the main on eat the
moment being that the Roundtable set-up we are working with can only
directly update native Progress databases.
When we make changes to the databases, we need to be able to easily, and as
automatically as possible, *update* the corresponding oracle databases with
these changes. As far as I have been able to work out, by experimenting and
from Tech Support, the only way I can migrate changes to the ORACLE database
is to create a new one every time changes have been made. To me this sounds
incredulous - that it is not possible to update databases - do people
seriously rebuild entire multi-gig databases just to add a couple of fields
or make changes to an index ?
I have seen that in V9, there is a utility to generate delta.sql files from
a Progress incremental .df file. This is just what I am looking for - but in
V8 !!! If I can somehow automate the process of converting a Progress .df
file to SQL that can then be run on the oracle database, I think this would
do what I am looking for.
I have tried to get Progress to tell me whether or not it is possible to
make / get hold of a version of the V9 utility that works in V8 as well. But
I have had problems getting through to them whether or not this is a good
idea or not. So far, not even a "no it is not possible because we use
something in V9 that isn't there in V8" kind of answer has been given. Tech
Support have been very persistent in the existing guidelines of building a
database. I can also enter en enhancement request in Progress' system on the
web - but I have not done this yet, as the time frame I am looking at is way
too short to wait for the processing of ENHRQs.
Can anyone help me out with here - even with contacts to others that can
help me ? I am very keen on finding a reasonable solution for this - and it
is not upgrading to V9 at the moment.
TIA
Thomas
___________________________________
Hansen IT Consulting
Frilandsvej 85
9800 Hjørring
Denmark
Tel.: +45 98 90 49 16
Fax.: +45 98 90 49 17
Mobile : +45 20 16 19 29
E-mail : thomas@hansenit.dk
Web : www.hansenit.dk
__________________________________
StarBase Corporation StarPartner and
Certified Roundtable Consultant
!! Available soon in Europe - the Astra and AstraGen Development Framework -
Future Proof RAD SmartObject development !!!
A couple of weeks ago I sent out a request for help with updating ORACLE
databases with changes that have been made to Progress databases. I did not
receive very much in the way of replies, so I am trying again. There must be
someone out there who is working with or has worked with a doable solution
for UPDATING oracle databases instead of having to create new databases
every time If there are - HELP )
The situation is as follows :
We are using Progress 8.3B (AIX server and NT clients).
I have just set up a system where our customer is going to be making their
primary database development against Progress databases instead of ORACLE
databases. There are a number of reasons for doing this, the main on eat the
moment being that the Roundtable set-up we are working with can only
directly update native Progress databases.
When we make changes to the databases, we need to be able to easily, and as
automatically as possible, *update* the corresponding oracle databases with
these changes. As far as I have been able to work out, by experimenting and
from Tech Support, the only way I can migrate changes to the ORACLE database
is to create a new one every time changes have been made. To me this sounds
incredulous - that it is not possible to update databases - do people
seriously rebuild entire multi-gig databases just to add a couple of fields
or make changes to an index ?
I have seen that in V9, there is a utility to generate delta.sql files from
a Progress incremental .df file. This is just what I am looking for - but in
V8 !!! If I can somehow automate the process of converting a Progress .df
file to SQL that can then be run on the oracle database, I think this would
do what I am looking for.
I have tried to get Progress to tell me whether or not it is possible to
make / get hold of a version of the V9 utility that works in V8 as well. But
I have had problems getting through to them whether or not this is a good
idea or not. So far, not even a "no it is not possible because we use
something in V9 that isn't there in V8" kind of answer has been given. Tech
Support have been very persistent in the existing guidelines of building a
database. I can also enter en enhancement request in Progress' system on the
web - but I have not done this yet, as the time frame I am looking at is way
too short to wait for the processing of ENHRQs.
Can anyone help me out with here - even with contacts to others that can
help me ? I am very keen on finding a reasonable solution for this - and it
is not upgrading to V9 at the moment.
TIA
Thomas
___________________________________
Hansen IT Consulting
Frilandsvej 85
9800 Hjørring
Denmark
Tel.: +45 98 90 49 16
Fax.: +45 98 90 49 17
Mobile : +45 20 16 19 29
E-mail : thomas@hansenit.dk
Web : www.hansenit.dk
__________________________________
StarBase Corporation StarPartner and
Certified Roundtable Consultant
!! Available soon in Europe - the Astra and AstraGen Development Framework -
Future Proof RAD SmartObject development !!!