Exporting routines from a data development project to a script

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:

  1. 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.
  2. 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.

Feedback