A Microsoft data-tier-application also known as a DAC is a self-contained unit of deployment that enables data-tier developers and DBAs to package SQL Server objects, including database and instance objects, into a single entity called DAC package or DACPAC.
A Microsoft data-tier-application also known as a DAC is a self-contained unit of deployment that enables data-tier developers and DBAs to package SQL Server objects, including database and instance objects, into a single entity called DAC package. Developers can build a DAC package using the Data-tier Application project system in Visual Studio, whereas SQL Server Management Studio (SSMS) users can extract a DAC and generate a DAC package file for an existing database.
A DAC package can be deployed to an instance of SQL Server to create a new DAC instance. The DAC deployment installs a new database on the instance, creates the database objects, and creates the logins associated with the users of the database. If a previous version of the DAC is already available, the DAC package can be used to upgrade the existing DAC instance to a newer version.
