In the Data Project Explorer, you can work locally with data objects.
The Data Project Explorer displays the following projects:
- Data
design projects
Data design projects are used for database design and information
integration. Use this type of project to develop physical data models,
logical
data models, domain
models, glossary
models, XSD
models, and scripts.
- Physical
data models can be used to generate DDL statements that can be deployed to
a database server.
- Logical
data models are not specific to a database that describes things about which
an organization wants to collect data, and the relationships among these things.
You can generate physical data models or UML models from logical data models.
- Domain
models describe an organization's allowed atomic domain types and their constraints.
You can specify atomic domains as data types for physical and
logical data models. Atomic
domains can also be specified as an integrated part of a logical data model.
- Glossary
models are used to validate a data model for naming standard compliance, or
to determine naming conventions.
- Data
development projects
Data development projects are used for database application
development. This type of project is associated with a single connection in
the Data Source Explorer. Use data development projects to develop the following
resources:
- You can develop, test, and deploy stored procedures and user-defined functions.
- If the target server supports XML, you can develop XML files and artifacts
for XML applications.
- You can also develop and test SQL queries.
- You can
develop and deploy Web services that access data by using SQL scripts or stored
procedures
Using the Data Project Explorer, you can also:
- Analyze
the impact and dependency of data objects
- Analyze
a data model to ensure model integrity
- Compare
two data objects
- Generate
DDL for data objects or data models
- Drag
and drop or copy database objects from the Data Source Explorer or from within
the Data Project Explorer
- Share projects using a source control system.