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.
| 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 :)CheersPaddy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
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 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Distributing New Stored Procedures