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 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 a SQL Server Technology Evangelist @ Northdoor PLC www.northdoor.co.uk

    The Leader of both the PASS London and Virtual Professional Development Chapters

    Neil is often found presenting @ international and domestic SQL events

  • Video