SQLBits 2010

DAC (Data Tier Applications) - Build and deploy your first Dacpac

DAC(Data Tier Applications) a new feature introduced in SQL Server 2008 R2, learn how this new feature can fit into your database deployment lifecycle strategies, monitor the health & performance of your DAC applications using Utility Explorer
DAC (Data Tier Applications) introduced in SQL Server® 2008 R2 release, in collaboration with Microsoft Visual Studio® 2010 it allows Developers & DBAs to develop and deploy Data Tier Applications in self-contained units (dacpacs) Using DACs, developers and database administrators can now automate common operations and design practices during their database lifecycles in controlled environments We will discuss the key features and perform some demonstrations of the development & then deployments of a dacpac, as with any new feature it presently has several limitations, we will discuss those and where/when this feature can be used to good effect.