DiscoverTechdays 2012 the Netherlands Sessions (Audio)Exploring SQL Server Data Tier Applications
Exploring SQL Server Data Tier Applications

Exploring SQL Server Data Tier Applications

Update: 2012-02-17
Share

Description

Data-tier applications (DAC) were introduced in 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. In this talk, I’ll show 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). I’ll also illustrate deployment to SQL Azure Database using Data Tier Applications and moving data and schema with the new DAC Import-Export Service.
Comments 
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

Exploring SQL Server Data Tier Applications

Exploring SQL Server Data Tier Applications

Bob Beauchemin