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.