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
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 1:55 PM
> 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: [EMAIL PROTECTED]
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
