Migrating stored procedures from test to production

The process that you follow to migrate a stored procedure from a test environment to production depends on the type of stored procedure that you want to migrate. The process that you follow also depends on the change management policy of your site. You can migrate a native SQL procedure, an external SQL procedure, or an external stored procedure. You also can choose to recompile to create new object code and a new package on the production server, or you can choose not to recompile.