SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


deploying sp into production


deploying sp into production

Author
Message
sandhyarao49
sandhyarao49
SSC Veteran
SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)

Group: General Forum Members
Points: 215 Visits: 650
Hi to all.
I have a small doubt.
If we create a new stored procedure how we have to deploy it in the production environment.
Is there any down time required.
Is there any need to send any mail to the clients while deploying the sp.
Could any one tell me the exact procedure we have to follow while moving
the sp in to production environment.


thanks,
Sandhya
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23347 Visits: 9730
I can't say what procedure you must follow. It depends on the company policy, etc.

Technically, it doesn't require anything at all except running the script. It's policy, customer and technical desires, etc., that make it more complex.

Most of the time, it shouldn't require any down-time to deploy a new proc (or modified version of an existing proc). If it requires any changes to the front-end application, then that might require some downtime, or might not, depending on the application and the change.

The right thing to do is figure out what impact the new proc will have. Will it affect what customers see/do? If so, letting them know is at least polite, and possibly necessary.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23347 Visits: 9730
I realized after I read my first post here that I'm making some assumptions.

I'm assuming you've tested the proc thoroughly.

I'm assuming you have a rollback script, so you can undo the change if it becomes necessary.

I'm assuming you have backups of the production database that can be restored if something goes horribly wrong.

I'm assuming you've coordinated the deployment with anyone else in IT/IS and with management.

Have you done those things?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3938 Visits: 1439
If you have done all the things Gsquare mentioned, then my guess is that you will not have any problems deploying the new store procedure. It will help if you will say what the sp does.




My blog

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search