Deploy a Routine wizard

Use the Deploy a Routine wizard to deploy exported stored procedures or user-defined functions to a database. The target database must be the same type as the database that the object was created for. You normally deploy routines that you exported using the Export a Routine wizard.

Before you deploy a routine, first export it to a script. If you export a routine to a project Scripts folder, you can deploy the routine using the Deploy a Routine wizard. If you export a routine to the file system, you can export it by following the instructions in the file called DeployInstructions.txt that was generated with the export script into the file folder that you specified during your export.