A data-tier application (DAC) is a logical database management entity that defines all of the SQL Server objects - like tables, views, and instance objects, including logins - associated with a user's database. A DAC is a self-contained unit of SQL Server database deployment that enables data-tier developers and database administrators to package SQL Server objects into a portable artifact called a DAC package, also known as a DACPAC.. GeoPITS brings you the comprehensive details of Support for data-tier application component operations - extract, deploy, upgrade, delete's support in different versions & editions of SQL Server.
Version | Enterprise | Standard | Web | Express (Adv.) | Express |
---|---|---|---|---|---|
Version v2019 | Yes | Yes | Yes | Yes | Yes |
Version v2017 | Yes | Yes | Yes | Yes | Yes |
Version v2016 | Yes | Yes | Yes | Yes | Yes |
Version v2014 | |||||
Version v2012 |
A data-tier application (DAC) is a logical database management entity that defines all of the SQL Server objects - like tables, views, and instance objects, including logins - associated with a user's database. A DAC is a self-contained unit of SQL Server database deployment that enables data-tier developers and database administrators to package SQL Server objects into a portable artifact called a DAC package, also known as a DACPAC.
You can find more details about this version here