Before you create routines or other database development
objects, create a data development project to store your objects.
A data development project is linked to one database connection in
the Data Source Explorer.
About this task
A data development project is used to store data application
development artifacts. You can store and develop the following types
of objects in a database development project:
- Stored procedures
- User-defined functions
- SQL scripts
- XML artifacts
- Web
services
You can also test, debug, export, and deploy these objects from
a data development project. The wizards that are available in a data
development project use the connection information that is specified
for the project to help you develop objects that are targeted for
that specific database.
Using the New Data Development Project
wizard, you specify basic information about the project, including
the name and default application settings such as default
schema. You also specify which database connection to use for the
project. You can use an existing connection or create a new connection.
To
create a data development project:
Results
If the database connection that you specified for your project
is deleted from the Data Source Explorer or becomes disconnected,
you will be prompted to reconnect before you can create or modify
objects in your data development project.