Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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
Report message to a moderator
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: 2016
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 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

Report message to a moderator
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: 5756
Registered: April 2002
Location: NL
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 24 15:20:43 CDT 2008

Total time taken to generate the page: 0.00935 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.