January 14, 2008 at 12:22 pm
Hello to all,
here at work, we have two servers each with MSSQL running. One database is where we do all of our testing, and one is actual production.
If we make a bunch of changes to stored procedures on the test server, how can I backup these procedures, and then restore the changes on our production server, without disturbing the list of users, database info, etc?
Thanks so much,
Chad Zeluff
January 14, 2008 at 12:27 pm
On the test server right-click the database --> tasks generate scripts --> select stored procs.
You will have select the option to create delete statements, so the previous version gets deleted.
Once you have the script, you can run it over your production box at your discretion.
January 14, 2008 at 12:34 pm
Much appreciation, Adam. Thank you 🙂
January 14, 2008 at 12:46 pm
NP thanks for the feedback. 😉
January 14, 2008 at 3:01 pm
oops sorry one more thing, Adam.
uh...how do I execute the script? It's a .sql file. Not sure what to do.
Sorry, still a n00b.
Chad Z
January 14, 2008 at 3:30 pm
Double click on the .sql file. This will open the file in SSMS then all you have to do is click the execute button 😉
January 14, 2008 at 3:31 pm
Make sure you have the right database selected in the drop down. If you have the correct database highlighted when you open the file; SSMS will default the connection to the correct database.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply