You can import routines to a data development project by using
a wizard or by dragging and dropping or copying and pasting a routine from
the Database Explorer or from another data development project. Use the Import
a Routine wizard to import stored procedures or user-defined functions to
your data development project. You can import routines from another data development
project, or you can import routines from the local file system.
To import a routine to a project:
- Switch to the Data perspective.
- Import routine using one of the following methods:
- In the Data Project Explorer, right-click either the Stored
Procedures or User-Defined Functions folder
under a data development project, and click Import from
the pop-up menu. Complete the steps of the Import a Routine wizard.
- Drag and drop a routine to a data development project from either
the Stored Procedures or User-Defined Functions folder
under a database connection in the Database Explorer or from another data
development project. You can only drag and drop routines that are supported
for development.
- Copy and paste a routine from the Database Explorer or from a data
development or data design project.
The routine is imported to the project in the appropriate folder.