In the Database Explorer, you can connect to existing databases
and view their designs and objects.
You can browse
database designs and import them to the Data Project Explorer, where you can
extend or modify the designs. You
can also run stored procedures and user-defined functions and view the results
in the Data Output view.
Using the Database Explorer, you can:
- Create a database connection
- Define connection filters
- Connect to existing databases and view their designs
- Reconnect to a database if your database connection was disconnected
- Disconnect from a database connection if you are connected
- Use saved connection information to view objects in a database even if
you are not actively connected
- Refresh the database objects that are defined for a database connection
- Delete a database connection
- Create new data
objects using the SQL editor
- Compare two data
objects
- Analyze
the impact and dependency of data objects
- Analyze a
data model to ensure model integrity
- Generate DDL from
a database, schema, or data object, and select the model objects that you
want to include in the DDL script
- Drag and drop
or copy database objects to the Data Project Explorer
- Drag
and drop stored procedures or user-defined functions into a Data Development
project, where you can modify and deploy the objects
- Deploy
stored procedures or user-defined functions to the same database or to a different
database