| Deployment Tools [message #331699] |
Fri, 04 July 2008 12:30  |
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
|
Senior Member |
|
|
Hi,
i don`t know if i am posting in the good section for this, but anyone know if any tools exist that can help for database deployment?
I am a developper but also the one responsible for the deployment of fix or bug correction for our application. Actually when i have to install a bug correction in our database, i have to open 10 SQL Plus application and run all script 10 time and recompile all database invalid object for all schema.
Is there any tools that could help me on doing that?
We are actually working with PLSQL Developer too that can help a bit for the recompilation of object and some install script. But what annoy me is having to open my application 10 time to do the installation. I can also open the application only once and change the connection after installing the first account and so on but this is usually taking more time so this is why i am usually opening 10 SQL Plus and i can run all installation at same time.
Is there any solution to this or if i only have to live with that problem?
Thank for your help.
|
|
|
|
| Re: Deployment Tools [message #331700 is a reply to message #331699] |
Fri, 04 July 2008 13:03  |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
You can put all the commands you need run in ONE SQL script, and then run just that one script in SQL*Plus do do your deployment.
You can connect to different databases in that script, or call as many other scripts as you like from it.
And then you can call one procedure to compile all invalid schema objects at the end. For example by using the procedures in the UTL_RECOMP package.
There no need that I can imagine that would require to open multiple SQLPLus applications to do it.
|
|
|
|
|
|
|
|
| Re: Deployment Tools [message #331703 is a reply to message #331701] |
Fri, 04 July 2008 13:18 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Very curious what solution you have in mind that it would depend on that info, especially the database version in 4 decimals specific..
|
|
|
|
| Re: Deployment Tools [message #331705 is a reply to message #331699] |
Fri, 04 July 2008 13:25 |
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
|
Senior Member |
|
|
I know it is possible to do it all in 1 script but i don`t want to hardcode in the script username and password of production database for security reason.
My question was more to know if there is any tool that can help during deployment of database object
Thank
|
|
|
|
|
|
| Re: Deployment Tools [message #331707 is a reply to message #331699] |
Fri, 04 July 2008 13:42 |
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
|
Senior Member |
|
|
You're right about substitution variable.
I will see if i can build some kind of template script for my installation since i don`t want to write the script for all installation.
You also confirmed me what i was thinking about SQL Plus being the best tool to do this
Thank for your help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
