TechEd Europe 2012

Exploring SQL Server Data Tier Applications

Download this episode

Download Video

Description

Data-tier applications (DAC) were introduced in Microsoft SQL Server 2008 R2. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects instead of having to manage them separately. Learn how to develop and deploy a DAC from scratch, how to create a DAC from an existing database, how to declare intent (such as which version and edition of SQL Server and the OS is required) when deploying, and how to manage DACs with SQL Server Management Studio in conjunction with SQL Server 2008 R2 utility control points (UCPs). We also illustrate deployment to SQL Azure Database using Data Tier Applications and moving data and schema with the new DAC Import-Export Service. #TEDBI309
For more information, check out this course on Microsoft Virtual Academy:

Day:

4

Level:

300

Code:

DBI309

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.