| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Upgrading Scheme versions
Hi Ronen,
In all the shops I have worked in, when we released a new version of the system (including changes to the schema), we would 'version' the application. All new development would happen against the new version, but bug fixes could be checked (and patches generated from) the 'frozen' previous version. We could then open that previous 'version', and run the reconcile against the currently implemented database (which would have all the changes since the last version).
Alternatively, if I remember correctly, you might be able to specify the set of scripts to use (certainly you can do that to 'reverse engineer' a database).
Finally, take the scripts, run them to create a pristine new database, and use this resulting database (if you are not happy to use your 'existing' database) to run the reconcile against ...
Oweson
> Hi Oweson,
>
> Thanks for your reply.
>
> I'm familier with the 'reconcile' feature of the designer but it gives me
> the ability to create a diff between Exisiting schema and the repository,
> while I have in the sourcesafe the scripts for the current version of the
> database.
>
> I want to be able to create a difference (upgrade script) between two
> installation scripts, hope that I explain the problem good enough.
>
> We keep in the sourcesafe script that enable us to create a new version of
> our software from scratch. We need the way to create upgrade version as
> well.
>
> Let me know if you have any resolving for this ....
>
> Thnx in advance,
>
> Ronen.
>
>
>
>
>
> -----Original Message-----
> Sent: Wednesday, February 07, 2001 1:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Ronen,
>
> Designer also has the ability to 'reconcile' the differences between the
> repository and the physical database. Running this report gives you 3
> options (output types) (if I remember correctly)
>
> - the first gives a text report of the differences;
> - the second will allow you to synchronise the repository with the
database.
> i.e., the repository will be updated to reflect the state of the physical
> database;
> - and lastly bring the database into line with the repository - it
attempts
> to generate scripts that will modify the database, and make it the same as
> the definition in the repository. (things like dropping columns are beyond
> it, and need to be done manually; also dropping foreign keys which are
> referenced etc.)
>
> >From what I understand, the 3rd option is what you are trying to do ...
>
> Hope this helps
>
> Regards
> Oweson Flynn
> ------------------------------------------------------------------
> Certified Oracle DBA
> The Flynn Consultancy
> Tel: 082-600-7-006
> Fax: (011) 782-9313
> EMail: oef_at_icon.co.za
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, February 05, 2001 2:30 PM
>
>
> > Hi all,
> >
> > We've developing using Oracle8i and Designer2000 tools.
> >
> > We've got one major scheme and need a methodology for updating the
> installed
> > version with scripts.
> >
> > For example -
> >
> > I have my product version 1.0 installed and I want to upgrade it to
> version
> > 2.0.
> >
> > I have scripts created by the designer to create clean new version 2.0,
> but
> > don't have any scripts to perform an upgrade.
> >
> > Do you have any methodology for doing upgrades between versions?
> >
> > Thnx,
> >
> > Ronen Levit
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ronen Levit
> > INET: ronen.levit_at_talmai.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
>
>
> ********************************************************************
>
> This message may contain information which is confidential and subject to
> legal privilege. If you are not the intended recipient, you may not
peruse,
> use, disseminate, distribute or copy this message. If you have received
this
> message in error, please notify the sender immediately by email, facsimile
> or telephone and return and/or destroy the original message.
>
> *******************************************************************
>
>
> *******************************************************************
>
> This message may contain information which is confidential and subject to
> legal privilege. If you are not the intended recipient, you may not
peruse,
> use, disseminate, distribute or copy this message. If you have received
this
> message in error, please notify the sender immediately by email, facsimile
> or telephone and return and/or destroy the original message.
>
> *******************************************************************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oweson Flynn
> INET: oweson.flynn_at_liberty.co.za
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ronen Levit
> INET: ronen.levit_at_talmai.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message.
This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn INET: oweson.flynn_at_liberty.co.za Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Feb 07 2001 - 08:02:32 CST
 |
 |