Use the Export a Routine wizard to export stored procedures or
user-defined functions from a data development project to a script
file on the file system for later deployment. You can also choose to create
a ZIP file that includes all associated export files.
The following instructions apply to routines that are stored in
a data development project.
To export a routine to a script:
- Switch to the Data perspective.
- In the Project Explorer, right-click a routine or either the Stored
Procedure or User-Defined Functions folder,
and click Export from the pop-up menu. The
Export a Routine wizard opens.
- Complete the steps of the wizard.
The export script is saved in the file system in the directory that
you specified in the wizard. In that directory you will also find a file called DeployInstructions.txt that
contains instructions that describe how to deploy the script. The export script
is either an SQL file or an XML file, depending on the routine type and target
database.