<html xmlns:rddl="http://www.rddl.org/" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns="http://www.w3.org/1999/xhtml"><head><title>SQL Server DacFx Serialization Schema</title></head><body><h1>SQL Server DacFx Serialization Schema</h1>April 2014<h2>Description</h2>This XML Schema covers the serialization schema of the SQL Server 2012 Data-Tier Application package for .dacpac and .bacpac. It covers the schema of several different streams within the package:
<ul xmlns="http://www.w3.org/1999/xhtml"><li>DacMetadata.xml<br/>
This stream contains the user-defined metadata associated with the DAC package. This information, contained under the DacType root node, includes the Application Name, the Version, and the Description of the DAC package.</li><li>Origin.xml<br/>
This stream contains information regarding the original database from which the DACPAC or BACPAC was created and is contained in the DacOrigin root element. This information includes properties of the actual package as well as the platform/version of the source server and a summary of object counts in the source database. This stream also contains the checksum of the Model.xml file which represents the full declarative schema definition of the database.</li><li>Model.xml<br/>
This is the primary stream inside the package and contains the schema information that defines the database that the package represents. Under the DataSchemaModel root node is the Model definition which includes the set of Database Options and all of the other annotations, properties and objects that define the database schema as well as dependencies  within the database schema itself.</li></ul><h2>Schema for SQL Server DacFx Serialization Schema</h2>Current version: <rddl:resource id="SQL_Server_DacFx_Serialization_Schema" xlink:title="SQL_Server_DacFx_Serialization_Schema" xlink:role="http://www.w3.org/2001/XMLSchema" xlink:arcrole="http://www.rddl.org/purposes#schema-validation" xlink:href="dacpac.xsd" xlink:type="simple" xlink:show="none" xlink:actuate="none"><a href="dacpac.xsd">dacpac.xsd</a></rddl:resource><br/></body><body><br/><table width="60%"><font size="-2">(c) 2014 Microsoft Corporation.  All rights reserved. The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema.  Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </font></table></body></html>