Home » Other » General » create/distribute upgrade package (10.2.0.3, win 2003/xp)
create/distribute upgrade package [message #311455] Fri, 04 April 2008 09:35 Go to next message
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
Re: create/distribute upgrade package [message #311497 is a reply to message #311455] Fri, 04 April 2008 11:34 Go to previous messageGo to next message
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.
Re: create/distribute upgrade package [message #311518 is a reply to message #311455] Fri, 04 April 2008 12:25 Go to previous messageGo to next message
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

Re: create/distribute upgrade package [message #311542 is a reply to message #311518] Fri, 04 April 2008 13:16 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: create/distribute upgrade package [message #311543 is a reply to message #311542] Fri, 04 April 2008 13:25 Go to previous message
SueC
Messages: 4
Registered: March 2008
Location: Baltimore, MD
Junior Member
yes, rerun and testing is alway considered.

thanks
Previous Topic: crash dump file
Next Topic: Book
Goto Forum:
  


Current Time: Sat Dec 10 22:14:40 CST 2016

Total time taken to generate the page: 0.08990 seconds