You can access data objects from the Data perspective (select
). Use the Data perspective to browse or import data objects in the Data Source Explorer, create and work with data objects in the Data Project Explorer, and modify data object properties in the Properties view. You can also deploy data objects to another database that is remote.The database tools provide a metadata model that is used by all other tools that need database information. This metadata model includes connection information so that tools can share connections.
You can also use the database tools to create, edit, and use views, stored procedures, and user-defined functions.
In the Data Project Explorer, you can work locally with data objects. The Data Project Explorer can hold data design projects and data development projects. You can generate DDL for data objects or data models. You can also deploy stored procedures or user-defined functions to a database that is either local or remote. In the Data Source Explorer, you can connect to an existing database and view its designs and objects. You can also drag and drop or copy objects into the Data Project Explorer.