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. 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:

  1. Switch to the Data perspective.
  2. 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.
  3. 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.
Related reference
Export a Routine wizard - Target and Options page
Related information
Desplegar rutinas en una base de datos
Importar rutinas a un proyecto

Comentarios