deploying sp into production

Question

deploying sp into production

sandhyarao49

SSCrazy

Points: 2215
More actions
June 6, 2008 at 11:24 am

#122586

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

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 SSC Guru Points: 260824 More actions · Answer 2

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 SSC-Insane Points: 20443 More actions · Answer 3

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