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 or for import
to a different workspace. You can also choose to create a ZIP
file that includes all associated export files.
About this task
The following instructions apply to routines that are
stored in a data development project.
Procedure
To export a routine to a script:
- 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 Routines wizard opens.
- Complete the steps of the wizard.
Results
The export script is saved in the file system in the directory
that you specified in the wizard.