Deploy Stored Procedures into Production SQL Database Server

Question

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.

Senthilkumar · Answer

Hi 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 Shaikh · Answer

Hi Gerald 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.