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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-08 : 09:16:59
|
| Tanveer writes "We have a web based accounting system where for each user we have different database including tables and stored procedures.We are on continuous development phase, so the problem we are facing is, if we change the functionalities of the stored procedures, this change will effect on the new databases and not on the existing users databases. Please let me know any procedure by which we update the latest changes in stored procedure to the new and existing databases with littile ease.I am looking forward to your responses.Best Regards," |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-08 : 11:59:56
|
| You can replication stored procedures using replication, but I would not suggest using this to deploy code to production. You can easily generate the code for your stored procedures by right clicking on the database, going to all tasks, then to generate sql script. Then copy this file to your other environments and run it. I hope that you deploy to QA first before deploying to production.Tara |
 |
|
|
|
|
|
Can we replicate the stored procedures script from one database to others?