OraFAQ Forum: General » create/distribute upgrade package

Home » Other » General » create/distribute upgrade package (10.2.0.3, win 2003/xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create/distribute upgrade package [message #311455]

Fri, 04 April 2008 09:35

SueC
Messages: 4
Registered: March 2008
Location: Baltimore, MD

Junior Member

Hi, could someone recommend a way to bundle my schema patch scripts and distribute to customers for database upgrades. I am considering a batch file that will execute scripts in version order but I was wondering what else people are doing to accomplish this.

Any ideas would be appreciated,
Sue

Report message to a moderator

Re: create/distribute upgrade package [message #311497 is a reply to message #311455]

Fri, 04 April 2008 11:34

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you can include the scripts in a batch file that should suffice. Course, it's always best to run the batch file that you are distributing in a test environment to ensure the file(s) run without errors.

Report message to a moderator

Re: create/distribute upgrade package [message #311518 is a reply to message #311455]

Fri, 04 April 2008 12:25

SueC
Messages: 4
Registered: March 2008
Location: Baltimore, MD

Junior Member

I just talked with a Delphi developer and I think he can create utility to handle the upgrades pretty easily.

Thanks!
Happy Friday
Cool

Report message to a moderator

Re: create/distribute upgrade package [message #311542 is a reply to message #311518]

Fri, 04 April 2008 13:16

Frank
Messages: 7901
Registered: March 2000

Senior Member

Make sure your scripts are rerunnable. It won't be the first time data gets corrupted because an installation script was run twice, or aborted in the middle of a transaction.

Report message to a moderator

Re: create/distribute upgrade package [message #311543 is a reply to message #311542]

Fri, 04 April 2008 13:25

SueC
Messages: 4
Registered: March 2008
Location: Baltimore, MD

Junior Member

yes, rerun and testing is alway considered.

thanks

Report message to a moderator

Previous Topic:	crash dump file
Next Topic:	Book

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 05:20:09 CST 2024