
302
|
Chapter 9, Server Explorer Hacks
#74 Diagram and Modify a Database
HACK
HACK
#74
Diagram and Modify a Database Hack #74
Why leave Visual Studio to administer your database? Use the Server Explorer
to create tables, views, stored procedures, and more.
We all love to hate SQL Server Enterprise Manager and its seemingly end-
less number of modal dialogs and nonsizable forms, but the Server Explorer
allows you to work with your database from a development perspective. It
doesn’t include all the features that Enterprise Manager does, but it pro-
vides the basics needed to work with your database. Figure 9-6 shows the
basic database interface included with the Server Explorer.
The capabilities of the data tools in Visual Studio vary based
on the version of Visual Studio you own. For a complete list
of capabilities, please refer to http://msdn.microsoft.com/
library/default.asp?url=/library/en-us/vdbt7/html/dvconvisual-
databasetoolseditions.asp.
Figure 9-5. Performance Counter Builder screen