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

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.
Presented by Neil Hambly at SQLBits VII
  • Downloads
  • SpeakerBIO
    neil_hambly.png
    Neil Hambly is a SQL veteran with over 15 years’ expertise in SQL Server from Version 6.5 through to the very latest 2012 edition. Neil has held numerous DB roles at major organizations such as BBC, ABN AMRO, ACCENTURE, alongside a number of smaller companies, with prior roles as both a DBA ,Developer & Architect, He is now the Principle Database Engineer @ ASOS. He is a PASS UK Regional Mentor & leader of SQL London PASS Chapter, often seen speaking @ international and national SQL events
    http://sqlblogcasts.com/blogs/NeilHambly
  • Video