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 Data Source 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 Data Source 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
Data Source Explorer or from a data
development or data design project.
The routine is imported to the project in the appropriate
folder.