Deploy Stored Procedures into Production SQL Database Server
Hi, I have this sets of stored procedure written using SQL Server Express 2008, how am I be able to deploy those stored procedure into a production database server. Please guide me, thank you so much.
SenthilkumarPosted Apr 27, 2012, 10:23 PM
Either you can use the script procedure as by right click the selected stored procedure.
Usually what they used to do when moving from staging to production, they will delete all the records and backup/restore it if it is fresh database.
Javeed M ShaikhPosted Apr 27, 2012, 4:37 PM
did you try creating the script of the stored procedure and running the same on the production database. Please consult your DBA/project incharge before deploying anything in production as that might break any existing functionality.