Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Distributing New Stored Procedures

Author  Topic 

pablod80
Starting Member

2 Posts

Posted - 2010-11-10 : 14:50:01
Hi There,

Apologies if this is the wrong forum
Wondering if someone can help me on something - i'm looking to help a colleague out.

Basically we have an asp.net web application in place running on MS SQL 2005 as the live application. (everything working fine for the past few years etc.)

The application is to get a new big update, that will require approx 20+ new stored procedures to be implemented onto the SQL Database.

Just wondering what would be be best way to implement these to the SQL?
obviousily the app will be taken offline/backed-up etc.. while work is carried out.
But would it be easier to just run the stored procedures on the existing SQL database or use the SQL database we are using during development and import the live data back into it?

Hopefully someone can point me in the right direction :)
Cheers
Paddy

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-10 : 14:58:10
Definitely do not use the development database and import live data back in. That will take much too long.

Just script out your changes and deploy that script to production. It'll take just seconds to deploy.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pablod80
Starting Member

2 Posts

Posted - 2010-11-10 : 15:30:34
Thank you Tara,
Sorry I'm a bit of a newbie to this myself,
Do you mean just script all the procedures and run them one by one?
or script them all in one go?

I'm just concerned that we may have missed one or two of the procedures
But I supposed thats all part of the testing
Thanks Again
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-10 : 15:39:56
Script them all in one go.

We script directly from our source control. If it's not in source control, it doesn't get deployed to QA, performance, or production. And our QA process should catch anything that didn't make it from development into production.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -