All the Oracle Scripts in Single XML File [message #418653] |
Tue, 18 August 2009 00:23  |
Hemanth123
Messages: 56 Registered: April 2009
|
Member |
|
|
Hi,
I was told to merge all the Oracle Scripts which I have written(Tables,Views,Alter Scripts,Functions,Triggers,Packages) into a single XML file as it would be easy for the DOT NET frame work to execute all the scripts at once.
The reason I was told is that instead of maintaining so many scripts and execute each one(of course as a batch file at one time)
why can't be it done in a single file.
Please let me know whether is it a good idea to merge all the scripts into a single file of XML type and if it is could any one give me a sample script so that it would be helpful for me.
Thanks in Advance,
Hemanth
|
|
|
|
|
Re: All the Oracle Scripts in Single XML File [message #418695 is a reply to message #418653] |
Tue, 18 August 2009 03:31   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I'd reply that the maintenance required would not be reduced by putting al the scripts into a single piece of XML - rather it would increase as it would be harder to find each individual piece of code, and harder to test each change made in isolation.
|
|
|
|
|