Specifications

Visual Studio 2010 and Data-Tier Application Projects CHAPTER 3 45
■
Type: User-dened Data Type
■
Type: User-dened Table Type
■
User
■
View
Database administrators do not have to worry about looking for unsupported objects. This
laborious task is accomplished with the Extract Data-Tier Application Wizard. Unsupported
objects such as DDL triggers, service broker objects, and full-text catalog objects are identied
and reported by the wizard. Unsupported objects are identied with a red icon that represents
an invalid entry. Database administrators must also pay close attention to objects with a yellow
icon, because this communicates a warning. A yellow icon usually warns database administra-
tors that although an object is supported, it is linked to and quite reliant on an unsupported
object. Database administrators need to review and address all objects with red and yellow
icons. The wizard does not create a DAC package until unsupported objects are removed. For
a list of some common supported objects, review the topic "SQL Server Objects Supported in
Data-tier Applications” at http://msdn.microsoft.com/en-us/library/ee210549(SQL.105).aspx.
Visual Studio 2010 and Data-Tier Application Projects
By leveraging the new project DAC template in Visual Studio 2010, data-tier developers
can create new data-tier applications from scratch or edit existing data-tier applications by
importing them directly into a project. Data-tier developers then add database objects such
as tables, views, and stored procedures to the data-tier application project. Data-tier devel-
opers can also dene specic deployment requirements for the data-tier application. When
the data-tier application project is complete, the data-tier developer creates a single unit of
deployment, known as a DAC le package, from within Visual Studio 2010. This package is
delivered to a database administrator, who deploys it to one or more SQL Server 2008 R2
instances. Alternatively, database administrators can use the DAC package to upgrade an
existing data-tier application that has already been deployed.
Launching a Data-Tier Application Project Template in
Visual Studio 2010
The following steps describe how to launch a data-tier application project template in Visual
Studio 2010:
1. Launch Visual Studio 2010.
2. In Visual Studio 2010, select File, and then select New Project.
3. In the Installed Templates list, expand the Database node, and then select SQL Server.