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 the SQL Server Evangelist & lead consultant @ Northdoor PLC (MSFT Data Platform Gold partner), previous roles @ ABN AMRO, Accenture, ASOS, BBC, Confio Software with 15+ years in SQL Server roles
    Presented 120+ events, including 50 PASS Summit/24HOP/Rally/SQL Saturday, 20 European events (12 countries), 50 + UK (SQLBits, SQLRelay) 
    Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP (2015)

    SQL Cruise Technical Lead, Likes Guinness, Loves Whisky, Dancing

  • Video