ࡱ > S V H I J K L M N O P Q R a r bjbj͚ I\I\E D R R R L R e R @ H" " L n ( d d d d d d d $ h nk * e e H e X' X' X' , d X' d X' X' _K O 0\3+ ! . L , d e 0 e M k ! h k X O O k P X' e e X' e k > : [MS-DACPAC]: Data-Tier Application Schema File Format Structure Specification
Intellectual Property Rights Notice for Open Specifications Documentation
Technical Documentation. Microsoft publishes Open Specifications documentation for protocols, file formats, languages, standards as well as overviews of the interaction among each of these technologies.
Copyrights. This documentation is covered by Microsoft copyrights. Regardless of any other terms that are contained in the terms of use for the Microsoft website that hosts this documentation, you may make copies of it in order to develop implementations of the technologies described in the Open Specifications and may distribute portions of it in your implementations using these technologies or your documentation as necessary to properly document the implementation. You may also distribute in your implementation, with or without modification, any schema, IDLs, or code samples that are included in the documentation. This permission also applies to any documents that are referenced in the Open Specifications.
No Trade Secrets. Microsoft does not claim any trade secret rights in this documentation.
Patents. Microsoft has patents that may cover your implementations of the technologies described in the Open Specifications. Neither this notice nor Microsoft's delivery of the documentation grants any licenses under those or any other Microsoft patents. However, a given Open Specification may be covered by Microsoft HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=214445" Open Specification Promise or the HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=214448" Community Promise. If you would prefer a written license, or if the technologies described in the Open Specifications are not covered by the Open Specifications Promise or Community Promise, as applicable, patent licenses are available by contacting HYPERLINK "mailto:iplg@microsoft.com" iplg@microsoft.com.
Trademarks. The names of companies and products contained in this documentation may be covered by trademarks or similar intellectual property rights. This notice does not grant any licenses under those rights.
Fictitious Names. The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted in this documentation are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred.
Reservation of Rights. All other rights are reserved, and this notice does not grant any rights other than specifically described above, whether by implication, estoppel, or otherwise.
Tools. The Open Specifications do not require the use of Microsoft programming tools or programming environments in order for you to develop an implementation. If you have access to Microsoft programming tools and environments you are free to take advantage of them. Certain Open Specifications are intended for use in conjunction with publicly available standard specifications and network programming art, and assumes that the reader either is familiar with the aforementioned material or has immediate access to it.
Revision Summary
DateRevision HistoryRevision ClassComments06/04/20100.1MajorFirst release.09/03/20100.1.1EditorialChanged language and formatting in the technical content.02/09/20110.2MinorClarified the meaning of the technical content.07/07/20111.0MajorSignificantly changed the technical content.11/03/20112.0MajorSignificantly changed the technical content.01/19/20122.0No changeNo changes to the meaning, language, or formatting of the technical content.02/23/20122.0No changeNo changes to the meaning, language, or formatting of the technical content.03/27/20122.0No changeNo changes to the meaning, language, or formatting of the technical content.05/24/20122.0No changeNo changes to the meaning, language, or formatting of the technical content.06/29/20122.0No changeNo changes to the meaning, language, or formatting of the technical content.
Contents
TOC \f \h \t "DSTOC1-1,1,DSTOC1-2,2,DSTOC1-3,3,DSTOC1-4,4,DSTOC1-5,5,DSTOC1-6,6,DSTOC1-7,7,DSTOC1-8,8,DSTOC1-9,9,DSTOC2-2,2,DSTOC2-3,3,DSTOC2-4,4,DSTOC2-5,5,DSTOC2-6,6,DSTOC2-7,7,DSTOC2-8,8,DSTOC2-9,9,DSTOC3-3,3,DSTOC3-4,4,DSTOC3-5,5,DSTOC3-6,6,DSTOC3-7,7,DST HYPERLINK \l "_Toc328709821" 1 Introduction PAGEREF _Toc328709821 \h 5
HYPERLINK \l "_Toc328709822" 1.1 Glossary PAGEREF _Toc328709822 \h 5
HYPERLINK \l "_Toc328709823" 1.2 References PAGEREF _Toc328709823 \h 5
HYPERLINK \l "_Toc328709824" 1.2.1 Normative References PAGEREF _Toc328709824 \h 5
HYPERLINK \l "_Toc328709825" 1.2.2 Informative References PAGEREF _Toc328709825 \h 6
HYPERLINK \l "_Toc328709826" 1.3 Structure Overview PAGEREF _Toc328709826 \h 7
HYPERLINK \l "_Toc328709827" 1.3.1 Data-Tier Application XML Parts PAGEREF _Toc328709827 \h 7
HYPERLINK \l "_Toc328709828" 1.3.2 Document Structure PAGEREF _Toc328709828 \h 7
HYPERLINK \l "_Toc328709829" 1.3.2.1 XML Namespace PAGEREF _Toc328709829 \h 8
HYPERLINK \l "_Toc328709830" 1.4 Relationship to Protocols and Other Structures PAGEREF _Toc328709830 \h 8
HYPERLINK \l "_Toc328709831" 1.5 Applicability Statement PAGEREF _Toc328709831 \h 8
HYPERLINK \l "_Toc328709832" 1.6 Versioning and Localization PAGEREF _Toc328709832 \h 8
HYPERLINK \l "_Toc328709833" 1.7 Vendor-Extensible Fields PAGEREF _Toc328709833 \h 8
HYPERLINK \l "_Toc328709834" 2 Structures PAGEREF _Toc328709834 \h 9
HYPERLINK \l "_Toc328709835" 2.1 Management Model (MM) PAGEREF _Toc328709835 \h 9
HYPERLINK \l "_Toc328709836" 2.1.1 Instances PAGEREF _Toc328709836 \h 9
HYPERLINK \l "_Toc328709837" 2.1.2 Reference PAGEREF _Toc328709837 \h 11
HYPERLINK \l "_Toc328709838" 2.1.3 Key PAGEREF _Toc328709838 \h 11
HYPERLINK \l "_Toc328709839" 2.1.4 ReferenceKey PAGEREF _Toc328709839 \h 12
HYPERLINK \l "_Toc328709840" 2.1.5 KeyPatternType PAGEREF _Toc328709840 \h 12
HYPERLINK \l "_Toc328709841" 2.1.6 InstancesType PAGEREF _Toc328709841 \h 12
HYPERLINK \l "_Toc328709842" 2.1.7 ReferenceType PAGEREF _Toc328709842 \h 12
HYPERLINK \l "_Toc328709843" 2.1.8 ReferencesType PAGEREF _Toc328709843 \h 13
HYPERLINK \l "_Toc328709844" 2.2 Relational Engine (RE) PAGEREF _Toc328709844 \h 13
HYPERLINK \l "_Toc328709845" 2.2.1 CheckConstraint PAGEREF _Toc328709845 \h 13
HYPERLINK \l "_Toc328709846" 2.2.2 Column PAGEREF _Toc328709846 \h 14
HYPERLINK \l "_Toc328709847" 2.2.3 Database PAGEREF _Toc328709847 \h 15
HYPERLINK \l "_Toc328709848" 2.2.4 DatabaseRole PAGEREF _Toc328709848 \h 15
HYPERLINK \l "_Toc328709849" 2.2.5 DefaultConstraint PAGEREF _Toc328709849 \h 16
HYPERLINK \l "_Toc328709850" 2.2.6 DmlTrigger PAGEREF _Toc328709850 \h 16
HYPERLINK \l "_Toc328709851" 2.2.7 ForeignKeyColumn PAGEREF _Toc328709851 \h 17
HYPERLINK \l "_Toc328709852" 2.2.8 ForeignKeyConstraint PAGEREF _Toc328709852 \h 18
HYPERLINK \l "_Toc328709853" 2.2.9 IndexedColumn PAGEREF _Toc328709853 \h 18
HYPERLINK \l "_Toc328709854" 2.2.10 Login PAGEREF _Toc328709854 \h 19
HYPERLINK \l "_Toc328709855" 2.2.11 PrimaryKeyConstraint PAGEREF _Toc328709855 \h 19
HYPERLINK \l "_Toc328709856" 2.2.12 RelationalIndex PAGEREF _Toc328709856 \h 19
HYPERLINK \l "_Toc328709857" 2.2.13 ScalarParameter PAGEREF _Toc328709857 \h 21
HYPERLINK \l "_Toc328709858" 2.2.14 ScalarValuedFunction PAGEREF _Toc328709858 \h 21
HYPERLINK \l "_Toc328709859" 2.2.15 Schema PAGEREF _Toc328709859 \h 22
HYPERLINK \l "_Toc328709860" 2.2.16 SpatialIndex PAGEREF _Toc328709860 \h 22
HYPERLINK \l "_Toc328709861" 2.2.17 Statistics PAGEREF _Toc328709861 \h 23
HYPERLINK \l "_Toc328709862" 2.2.18 StoredProcedure PAGEREF _Toc328709862 \h 23
HYPERLINK \l "_Toc328709863" 2.2.19 Synonym PAGEREF _Toc328709863 \h 24
HYPERLINK \l "_Toc328709864" 2.2.20 Table PAGEREF _Toc328709864 \h 24
HYPERLINK \l "_Toc328709865" 2.2.21 TableParameter PAGEREF _Toc328709865 \h 25
HYPERLINK \l "_Toc328709866" 2.2.22 TableValuedFunction PAGEREF _Toc328709866 \h 25
HYPERLINK \l "_Toc328709867" 2.2.23 UniqueConstraint PAGEREF _Toc328709867 \h 26
HYPERLINK \l "_Toc328709868" 2.2.24 User PAGEREF _Toc328709868 \h 26
HYPERLINK \l "_Toc328709869" 2.2.25 UserDefinedDataType PAGEREF _Toc328709869 \h 27
HYPERLINK \l "_Toc328709870" 2.2.26 UserDefinedTableType PAGEREF _Toc328709870 \h 27
HYPERLINK \l "_Toc328709871" 2.2.27 View PAGEREF _Toc328709871 \h 28
HYPERLINK \l "_Toc328709872" 2.2.28 ActivationOrder PAGEREF _Toc328709872 \h 28
HYPERLINK \l "_Toc328709873" 2.2.29 BooleanType PAGEREF _Toc328709873 \h 28
HYPERLINK \l "_Toc328709874" 2.2.30 CompatibilityLevelEnumeration PAGEREF _Toc328709874 \h 29
HYPERLINK \l "_Toc328709875" 2.2.31 DMLActionEnumeration PAGEREF _Toc328709875 \h 29
HYPERLINK \l "_Toc328709876" 2.2.32 ExecuteAsEnumeration PAGEREF _Toc328709876 \h 30
HYPERLINK \l "_Toc328709877" 2.2.33 GridDensity PAGEREF _Toc328709877 \h 30
HYPERLINK \l "_Toc328709878" 2.2.34 LoginTypeEnumeration PAGEREF _Toc328709878 \h 30
HYPERLINK \l "_Toc328709879" 2.2.35 PermissionStateEnum PAGEREF _Toc328709879 \h 31
HYPERLINK \l "_Toc328709880" 2.2.36 PermissionTypeEnum PAGEREF _Toc328709880 \h 31
HYPERLINK \l "_Toc328709881" 2.2.37 SortOrderEnumeration PAGEREF _Toc328709881 \h 33
HYPERLINK \l "_Toc328709882" 2.2.38 UserTypeEnumeration PAGEREF _Toc328709882 \h 33
HYPERLINK \l "_Toc328709883" 2.2.39 FillFactorType PAGEREF _Toc328709883 \h 33
HYPERLINK \l "_Toc328709884" 2.2.40 MaxDopType PAGEREF _Toc328709884 \h 33
HYPERLINK \l "_Toc328709885" 2.2.41 BaseSystemDataType PAGEREF _Toc328709885 \h 34
HYPERLINK \l "_Toc328709886" 2.2.42 CollationType PAGEREF _Toc328709886 \h 34
HYPERLINK \l "_Toc328709887" 2.2.43 ComputedColumnType PAGEREF _Toc328709887 \h 34
HYPERLINK \l "_Toc328709888" 2.2.44 DatabasePermission PAGEREF _Toc328709888 \h 35
HYPERLINK \l "_Toc328709889" 2.2.45 DataType PAGEREF _Toc328709889 \h 35
HYPERLINK \l "_Toc328709890" 2.2.46 ExecutionContextType PAGEREF _Toc328709890 \h 35
HYPERLINK \l "_Toc328709891" 2.2.47 IdentityType PAGEREF _Toc328709891 \h 36
HYPERLINK \l "_Toc328709892" 2.2.48 Permissions PAGEREF _Toc328709892 \h 36
HYPERLINK \l "_Toc328709893" 2.2.49 ScalarDataType PAGEREF _Toc328709893 \h 37
HYPERLINK \l "_Toc328709894" 2.2.50 SqlDataType PAGEREF _Toc328709894 \h 37
HYPERLINK \l "_Toc328709895" 3 Structure Examples PAGEREF _Toc328709895 \h 38
HYPERLINK \l "_Toc328709896" 3.1 Pubs database (simplified) PAGEREF _Toc328709896 \h 38
HYPERLINK \l "_Toc328709897" 3.2 Logical object sample PAGEREF _Toc328709897 \h 38
HYPERLINK \l "_Toc328709898" 3.3 Physical object sample PAGEREF _Toc328709898 \h 40
HYPERLINK \l "_Toc328709899" 4 Security Considerations PAGEREF _Toc328709899 \h 43
HYPERLINK \l "_Toc328709900" 5 Appendix A: XML Schema PAGEREF _Toc328709900 \h 44
HYPERLINK \l "_Toc328709901" 5.1 Management Model XML Schema for Version 2009/08 PAGEREF _Toc328709901 \h 44
HYPERLINK \l "_Toc328709902" 5.2 Relational Engine XML Schema for Version 2009/08 PAGEREF _Toc328709902 \h 47
HYPERLINK \l "_Toc328709903" 5.3 Management Model XML Schema for Version 2010/11 PAGEREF _Toc328709903 \h 58
HYPERLINK \l "_Toc328709904" 5.4 Relational Engine XML Schema for Version 2010/11 PAGEREF _Toc328709904 \h 60
HYPERLINK \l "_Toc328709905" 5.5 Management Model XML Schema for Version 2011/03 PAGEREF _Toc328709905 \h 71
HYPERLINK \l "_Toc328709906" 5.6 Relational Engine XML Schema for Version 2011/03 PAGEREF _Toc328709906 \h 73
HYPERLINK \l "_Toc328709907" 6 Appendix B: Product Behavior PAGEREF _Toc328709907 \h 128
HYPERLINK \l "_Toc328709908" 7 Change Tracking PAGEREF _Toc328709908 \h 129
HYPERLINK \l "_Toc328709909" 8 Index PAGEREF _Toc328709909 \h 130
1 Introduction
A data-tier application (DAC) is a self-contained unit for developing, deploying, and managing data-tier objects. A DAC enables data-tier developers and database administrators (DBAs) to package Microsoft SQLServer objects, including HYPERLINK "[MS-GLOS].pdf" database and instance objects, into a single entity called a DAC package (.dacpac), as specified in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=178596" [MSDN-UNDERDAC]. A DAC package consists of multiple XML parts that represent metadata of the data-tier application and SQL Server object schema.
This document uses XML schema definitions to describe the file format of XML parts in a DAC package. Note that the XML schema HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608" [XMLSCHEMA1] definition ( HYPERLINK "[MS-GLOS].pdf" XSD) in HYPERLINK \l "z29a0e7d40c5f467daa84dd0890698087" Appendix A of this document is supplemental to the data portability scenarios that are described in [MS-DPDACPAC].
Sections 1.7 and 2 of this specification are normative and can contain the terms MAY, SHOULD, MUST, MUST NOT, and SHOULD NOT as defined in RFC 2119. All other sections and examples in this specification are informative.
1.1 Glossary
The following terms are defined in HYPERLINK "[MS-GLOS].pdf" [MS-GLOS]:
database objectXML schema (XSD)
The following terms are specific to this document:
MIME type: A method that is used by protocol clients to associate files of a certain type with applications that can open or access files of that type.
MAY, SHOULD, MUST, SHOULD NOT, MUST NOT: These terms (in all caps) are used as described in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90317" [RFC2119]. All statements of optional behavior use either MAY, SHOULD, or SHOULD NOT.
1.2 References
References to Microsoft Open Specifications documentation do not include a publishing year because links are to the latest version of the documents, which are updated frequently. References to other documents include a publishing year when one is available.
1.2.1 Normative References
We conduct frequent surveys of the normative references to assure their continued availability. If you have any issue with finding a normative reference, please contact HYPERLINK "mailto:dochelp@microsoft.com" dochelp@microsoft.com. We will assist you in finding the relevant information. Please check the archive site, HYPERLINK "http://msdn2.microsoft.com/en-us/library/E4BD6494-06AD-4aed-9823-445E921C9624" http://msdn2.microsoft.com/en-us/library/E4BD6494-06AD-4aed-9823-445E921C9624, as an additional source.
[RFC2119] Bradner, S., "Key words for use in RFCs to Indicate Requirement Levels", BCP 14, RFC 2119, March 1997, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90317" http://www.ietf.org/rfc/rfc2119.txt
[XML1.0] Bray, T., Paoli, J., Sperberg-McQueen, C.M., and Maler, E., "Extensible Markup Language (XML) 1.0 (Second Edition)", W3C Recommendation, October 2000, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90599" http://www.w3.org/TR/2000/REC-xml-20001006
[XMLSCHEMA1] Thompson, H.S., Ed., Beech, D., Ed., Maloney, M., Ed., and Mendelsohn, N., Ed., "XML Schema Part 1: Structures", W3C Recommendation, May 2001, HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=90608" http://www.w3.org/TR/2001/REC-xmlschema-1-20010502/
1.2.2 Informative References
[MS-GLOS] Microsoft Corporation, " HYPERLINK "[MS-GLOS].pdf" Windows Protocols Master Glossary".
[MS-DPDACPAC] Microsoft Corporation, " HYPERLINK "[MS-DPDACPAC].pdf" Data-Tier Application Data Portability Overview".
[MSDN-CDTS] Microsoft Corporation, "Create Database (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190585" http://msdn.microsoft.com/en-us/library/ms176061(v=SQL.105).aspx
[MSDN-CFTS] Microsoft Corporation, "Create Function (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190590" http://msdn.microsoft.com/en-us/library/ms186755(v=SQL.105).aspx
[MSDN-CHKCNST] Microsoft Corporation, "CHECK constraints", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190582" http://msdn.microsoft.com/en-us/library/ms188258(SQL.105).aspx
[MSDN-CITS] Microsoft Corporation, "Create Index (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190587" http://msdn.microsoft.com/en-us/library/ms188783(v=SQL.105).aspx
[MSDN-CLTS] Microsoft Corporation, "Create Login (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190589" http://msdn.microsoft.com/en-us/library/ms189751(v=SQL.105).aspx
[MSDN-CNSTS] Microsoft Corporation, "Constraints", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190581" http://msdn.microsoft.com/en-us/library/ms189862(SQL.105).aspx
[MSDN-COLLATE] Microsoft Corporation, "SQL Server Collation Name", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190636" http://msdn.microsoft.com/en-us/library/ms180175(SQL.105).aspx
[MSDN-COLUMNPROPERTY] Microsoft Corporation, "COLUMNPROPERTY (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190584" http://msdn.microsoft.com/en-us/library/ms174968(v=SQL.105).aspx
[MSDN-CPRTS] Microsoft Corporation, "Create Procedure (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190592" http://msdn.microsoft.com/en-us/library/ms187926(v=SQL.105).aspx
[MSDN-CRTS] Microsoft Corporation, "Create Role (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190586" http://msdn.microsoft.com/en-us/library/ms187936(v=SQL.105).aspx
[MSDN-CSTS] Microsoft Corporation, "Create Schema (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190593" http://msdn.microsoft.com/en-us/library/ms189462(v=SQL.105).aspx
[MSDN-CTGTS] Microsoft Corporation, "Create Trigger (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190588" http://msdn.microsoft.com/en-us/library/ms189799(v=SQL.105).aspx
[MSDN-CTTS] Microsoft Corporation, "Create Table (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190580" http://msdn.microsoft.com/en-us/library/ms174979(SQL.105).aspx
[MSDN-CTYTS] Microsoft Corporation, "Create Type (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190599" http://msdn.microsoft.com/en-us/library/ms175007(v=SQL.105).aspx
[MSDN-CUTS] Microsoft Corporation, "Create User (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190596" http://msdn.microsoft.com/en-us/library/ms173463(v=SQL.105).aspx
[MSDN-CVTS] Microsoft Corporation, "Create View (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190601" http://msdn.microsoft.com/en-us/library/ms187956(v=SQL.105).aspx
[MSDN-DACAPI] Microsoft Corporation, "Microsoft.SqlServer.Management.DAC Namespace", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=178607" http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.dac(SQL.105).aspx
[MSDN-DACSUPOB] Microsoft Corporation, "SQL Server Objects Supported in Data-tier Applications", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=178611" http://msdn.microsoft.com/en-us/library/ee210549(SQL.105).aspx
[MSDN-DTTS] Microsoft Corporation, "Data Types (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=157790" http://msdn.microsoft.com/en-us/library/ms187752.aspx
[MSDN-EATS] Microsoft Corporation, "Execute As (Transact-SQL)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190602" http://msdn.microsoft.com/en-us/library/ms181362(v=SQL.105).aspx
[MSDN-TVPDE] Microsoft Corporation, "Table-Valued Parameters (Database Engine)", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190595" http://msdn.microsoft.com/en-us/library/bb510489(v=SQL.105).aspx
[MSDN-TVUDF] Microsoft Corporation, "Table-Valued User-Defined Function", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190606" http://msdn.microsoft.com/en-us/library/ms191165(v=SQL.105).aspx
[MSDN-UDTT] Microsoft Corporation, "User-Defined Table Types", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190600" http://msdn.microsoft.com/en-us/library/bb522526(v=SQL.105).aspx
[MSDN-UNDERDAC] Microsoft Corporation, "Understanding Data-tier Applications", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=178596" http://msdn.microsoft.com/en-us/library/ee240739(SQL.105).aspx
[MSFT-REDACPAC200908] Microsoft Corporation, "Relational Engine XML Schema for Version 2009/08", HYPERLINK \l "z6fee9d13c3744d6e8b7c63e96988a7ea" http://schemas.microsoft.com/sqlserver/RelationalEngine/Serialization/2009/08
[MSFT-REDACPAC201111] Microsoft Corporation, "Relational Engine XML Schema for Version 2011/11", HYPERLINK \l "z83e07328cbaa46da9cc7b4e6cf65348e" http://schemas.microsoft.com/sqlserver/RelationalEngine/Serialization/2011/11
[MSFT-REDACPAC201103] Microsoft Corporation, "Relational Engine XML Schema for Version 2013/03", HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" http://schemas.microsoft.com/sqlserver/RelationalEngine/Serialization/2011/03
[MSFT-SSPS] Microsoft Corporation, "Microsoft SQL Server Community Projects & Samples", HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190583" http://sqlserversamples.codeplex.com/
1.3 Structure Overview
1.3.1 Data-Tier Application XML Parts
A data-tier application consists of the followin g t w o k i n d s o f i n f o r m a t i o n t o r e p r e s e n t d a t a b a s e a n d i n s t a n c e o b j e c t s :
L o g i c a l o b j e c t d e f i n i t i o n
P h y s i c a l o b j e c t d e f i n i t i o n
T h i s i n f o r m a t i o n i s s p e c i f i e d i n t h e X M L f o r m a t , a s s p e c i f i e d i n H Y P E R L I N K " h t t p : / / g o . m i c r o s o f t . c o m / f w l i n k / ? L i n k I d = 4 9 8 6 3 " [ X ML1.0], that complies with the XSD that is specified in this specification.
1.3.2 Document Structure
The root element of a data-tier application XML is an HYPERLINK \l "z458777d458224752b0de934dac113319" Instances element. Subelements of the Instances element can appear in any order. A collection can have multiple instances of a subelement.
1.3.2.1 XML Namespace
The namespace URIs for a data-tier application XML are:
http://schemas.microsoft.com/sqlserver/RelationalEngine/Serialization/yyyy/mm
http://schemas.microsoft.com/sqlserver/ManagementModel/Serialization/yyyy/mm
The date component (yyyy/mm) indicates the release date of particular version of data-tier application XML. The standard file name extension for XML parts in a data-tier application is *.xml. The HYPERLINK \l "z1" MIME type to use for XML files in a data-tier application is text/xml.
1.4 Relationship to Protocols and Other Structures
The data-tier application schema definition in this document supplements the data-portability scen a r i o s t h a t a r e d e s c r i b e d i n [ M S - D P D A C P A C ] .
1 . 5 A p p l i c a b i l i t y S t a t e m e n t
T h i s f o r m a t i s a p p l i c a b l e f o r u s e a s X M L p a r t s o f a . d a c p a c f i l e o r f o r u s e a s a u s e r s r e f e r e n c e .
1 . 6 V e r s i o n i n g a n d L o c a l i z a t i o n
T h e X S D v e r s i o n 2 0 0 9 / 0 8 i s r e l e a s e d i n M i c r o s o f t S Q L S e r v e r 2 0 0 8 R 2 .
T h e X S D v e r s i o n 2 0 1 0 / 1 1 i s r e l e a s e d i n t h e M i c r o s o f t S Q L S e r v e r 2 0 0 8 R 2 D A C o u t - o f - b a n d r e l e a s e .
T h e X S D v e r s i o n 2 0 1 1 / 0 3 i s r e l e a s e d i n M i c r o s o f t S Q L S e r v e r 2 0 1 2 .
T h e X S D v e r s i o n s f o r H Y P E R L I N K \ l " z 8 8 e d b 6 e 6 8 d b 2 4 6 2 1 a e 2 4 3 e 3 f 9 b 1 9 f b 0 f " M a n a g e m e n t M o d e l a n d H Y P E R L I N K \ l " z 6 f e e 9 d 1 3 c 3 7 4 4 d 6 e 8 b 7 c 6 3 e 9 6 9 8 8 a 7 e a " R e l a t i o n a l E n g i n e a r e s p e c i f i e d i n H Y P E R L I N K \ l " z 2 9 a 0 e 7 d 4 0 c 5 f 4 6 7 d a a 8 4 d d 0 8 9 0 6 9 8 0 8 7 " A p p e n d i x A .
T h e d a t a - t i e r a p p l i c a t i o n f i l e f o r m a t c o n t a i n s l o c a l i z a t i o n - i n d e p endent structures.
1.7 Vendor-Extensible Fields
The XML HYPERLINK "[MS-GLOS].pdf" schema definition and file structure of a .dacpac file is based on the design and implementation of Microsoft SQL Server 2008 R2 Data-Tier Application Framework HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=178607" [MSDN-DACAPI]. An extension of the XML schema in this document can result in unexpected behavior that is not supported by SQL Server 2008 R2 or Microsoft SQL Server 2012.
2 Structures
This section specifies the XML schema model, the HYPERLINK \l "z0592b1ebcfe449a3a6a40309bcebb846" Management Model (MM) and HYPERLINK \l "z6c9ec91113bb4cf0ac5c9e0f4b19e351" Relation Engine (RE) Model, of a data-tier application.
2.1 Management Model (MM)
Management Model (MM) is the logical structure definition of a data-tier application instance in XML. MM specifies instances of server and database objects. The logical structure and attributes of each server and database object is specified in the HYPERLINK \l "z6c9ec91113bb4cf0ac5c9e0f4b19e351" Relational Engine (RE) model. Instance elements in MM are designed to reference RE elements.
2.1.1 Instances
MM:Instances is the root element of a data-tier application. The MM:Instances element contains the subelements that are listed in the following table.
Subelements HYPERLINK \l "zd8fd2a4e13fd4274be427851b4955334" CheckConstraint HYPERLINK \l "z1371d5e7a4cc4dfcb49a2d2b6da11579" Column HYPERLINK \l "zc43f4e99fcad4f01981465dc80129fb8" Database HYPERLINK \l "zfec1d319657c4e09a2622249b91700a0" DatabaseRole HYPERLINK \l "zd745502928dd4c1db12d13f8c0be5e37" DefaultConstraint HYPERLINK \l "z48ceb91988634616999829ed67671e50" DmlTrigger HYPERLINK \l "zadf39f458396418baca74d6f987ddc9d" ForeignKeyColumn HYPERLINK \l "z7d5b150ac98749b4a7e4af29773578db" ForeignKeyConstraint HYPERLINK \l "z3be860ea6ec946a5a10544fe523f7597" IndexedColumn HYPERLINK \l "z4c908ce8c0ae48be8327b116d790ba57" Login HYPERLINK \l "z880d7c818d2646f4a52bcea7f136673b" PrimaryKeyConstraint HYPERLINK \l "za062fe9c93b042b890fc3623aed23144" RelationalIndex HYPERLINK \l "zc2a861de0e8249219a0bc97aa9c33ec1" ScalarParameter HYPERLINK \l "zf4aa8617946a48b79cc55b3e7d92b640" ScalarValuedFunction HYPERLINK \l "z0f6f3de3fea84babaf27935cf970cff9" Schema HYPERLINK \l "z1e1a0971b3254c31b1aa59f7ec60f5bb" SpatialIndex HYPERLINK \l "z4" <1> HYPERLINK \l "z1578fa0411204aad96de361e662eb7f6" Statistics HYPERLINK \l "z6" <2> HYPERLINK \l "z95cd1a8539d04abb9cdda59e387e21f8" StoredProcedure HYPERLINK \l "zcf12dc5649f7433fa83f2b4ad11066de" Synonym HYPERLINK \l "z8" <3> HYPERLINK \l "z24ec016638774998aaecdcb05f01134e" Table HYPERLINK \l "z12b36d6140ba4eaaacdf475e230874b0" TableParameter HYPERLINK \l "z4e73ec710b554d10866eb1563165af7f" TableValuedFunction HYPERLINK \l "ze91f5a7bb15c46e682abe40cc8cf2c37" UniqueConstraint HYPERLINK \l "z4292a080a3cf42128c3c2f231552415e" User HYPERLINK \l "z05fab12c8c0e468ea9f3acbaadfe6826" UserDefinedDataType HYPERLINK \l "z47fca62b13f7460ba407d9758d34ca00" UserDefinedTableType HYPERLINK \l "z4c74af72c0f84cfb94701c8ecc271a98" ViewThe following is the XML definition of the MM:Instances element for version 2009/08.
The following is the XML definition of the MM:Instances element for version 2011/03.
2.1.2 Reference
The MM:Reference element specifies a referential relationship between two RE elements in a data-tier application.
The following is the XML schema definition of the MM:Reference element.
2.1.3 Key
The MM:Key attribute specifies the unique identifier of a RE element instance in a data-tier application. All elements that are extended from HYPERLINK \l "z60ebe840932944129be0c7352cb47e3b" InstancesType MUST contain an MM:Key attribute.
The following is the XML schema definition of the MM:Key attribute.
2.1.4 ReferenceKey
The MM:ReferenceKey attribute specifies the unique identifier of the RE element instance that is referenced by another element in a data-tier application.
The following is the XML schema definition of the MM:ReferenceKey attribute.
2.1.5 KeyPatternType
The MM:KeyPatternType simple type specifies a regular expression for HYPERLINK \l "z4a29354116724245bf8e3ef38a8e1156" MM:Key and HYPERLINK \l "za4b2f4d1561c4d16b7813d65be3659cc" MM:ReferenceKey in a data-tier application.
The following is the XML definition of the MM:KeyPatternType simple type.
2.1.6 InstancesType
The MM:InstancesType is a complex type to set the mandatory attributes for all elements in a data-tier application.
The following is the XML definition of the MM:InstancesTypecomplex type.
2.1.7 ReferenceType
The MM:ReferenceType is a complex type to set the mandatory attributes for all reference elements in a data-tier application.
The following is the XML definition of the MM:ReferenceType complex type.
2.1.8 ReferencesType
The MM:ReferencesType is a complex type that specifies a collection of multiple reference elements in a data-tier application.
The following is the XML definition of MM:ReferenceType complex type.
2.2 Relational Engine (RE)
The Relational Engine (RE) model specifies the XML schema of server and database objects and the metadata within a data-tier application.
The following subsections specify the objects supported by the data-tier application.
2.2.1 CheckConstraint
The RE:CheckConstraint element specifies the metadata of a check constraint in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190582" [MSDN-CHKCNST].
The following is the XML schema definition of the RE:CheckConstraint element for version 2009/08 HYPERLINK \l "z6fee9d13c3744d6e8b7c63e96988a7ea" [MSFT-DACPACRE200908].
The following is the XML schema definition of the RE:CheckConstraint element version 2011/11 HYPERLINK \l "z83e07328cbaa46da9cc7b4e6cf65348e" [MSFT-REDACPAC201111]. This definition adds the NotForReplication option property.
The following is the XML schema definition of the RE:CheckConstraint element version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103].
2.2.2 Column
The RE:Column element specifies the metadata of a table or view column in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190584" [MSDN-COLUMNPROPERTY] and HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190580" [MSDN-CTTS].
The following is the XML schema definition of the RE:Column element.
2.2.3 Database
The RE:Database element specifies the metadata of a database in a data-tier application. Note that RE:Database specifies a subset of attributes that are described in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190585" [MSDN-CDTS].
The following is the XML schema definition of the RE:Database element.
2.2.4 DatabaseRole
The RE:DatabaseRole element specifies the metadata of a database role in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190586" [MSDN-CRTS].
The following is the XML schema definition of the RE:DatabaseRole element for version 2009/08.
The following is the XML schema definition of the RE:DatabaseRole element for version 2011/03.
2.2.5 DefaultConstraint
The RE:DefaultConstraint element specifies the metadata of a default constraint in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190581" [MSDN-CNSTS].
The following is the XML schema definition of the RE:DefaultConstraint element.
2.2.6 DmlTrigger
The RE:DmlTrigger element specifies the metadata of a trigger that is associated with TABLE or VIEW DML statements in a data-tier application. For more information about trigger, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190588" [MSDN-CTGTS].
The following is the XML schema definition of the RE:DmlTrigger element for version 2009/08.
The following is the XML schema definition of the RE:DmlTrigger element for version 2011/03.
2.2.7 ForeignKeyColumn
The RE:ForeignKeyColumn element specifies the metadata of a column that is referenced by a foreign key in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190581" [MSDN-CNSTS].
The following is the XML schema definition of the RE:ForeignKeyColumn element.
2.2.8 ForeignKeyConstraint
The RE:ForeignKeyConstraint element specifies the metadata of a foreign key in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190581" [MSDN-CNSTS].
The following is the XML schema definition of the RE:ForeignKeyConstraint element.
2.2.9 IndexedColumn
The RE:IndexedColumn element specifies the metadata of an indexed column in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190587" [MSDN-CITS].
The following is the XML definition of the RE:IndexedColumn element.
2.2.10 Login
The RE:Login element specifies the metadata of a login in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190589" [MSDN-CLTS]. Note that RE:Login in data-tier application supports a subset of attributes that are described in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190589" [MSDN-CLTS].
The following is the XML schema representation of the RE:Login element.
2.2.11 PrimaryKeyConstraint
The RE:PrimaryKeyConstraint element specifies the metadata of a primary key in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190581" [MSDN-CNSTS].
The following is the XML schema representation of the RE:PrimaryKeyConstraint element.
2.2.12 RelationalIndex
Applies to DACPAC version HYPERLINK \l "z6fee9d13c3744d6e8b7c63e96988a7ea" [MSFT-REDACPAC200908] and DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
The RE:RelationalIndex element specifies the metadata of an index in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190587" [MSDN-CITS].
The following is the XML schema definition of the RE:RelationalIndex element for version 2009/08 [MSFT-DACPACRE200908].
The following is the XML schema definition of the RE:RelationalIndex element for version 2011/03 [MSFT-REDACPAC201103].
2.2.13 ScalarParameter
The RE:ScalarParameter element specifies the metadata of a function or stored procedure parameter with scalar values in a data-tier application. For more information, refer to parameters in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190590" [MSDN-CFTS] or HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190592" [MSDN-CPRTS].
The following is the XML schema definition of the RE:ScalarParameter.
2.2.14 ScalarValuedFunction
The RE:ScalarValuedFunction element specifies the metadata of a function that returns a scalar value in a data-tier application. For more information on function, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190590" [MSDN-CFTS].
The following is the XML schema definition of the RE:ScalarValuedFunction element.
2.2.15 Schema
The RE:Schema element specifies the metadata of the database schema in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190593" [MSDN-CSTS].
The following is the XML schema definition of the RE:Schema element.
2.2.16 SpatialIndex
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
The RE:SpatialIndex element specifies the metadata of a stored procedure in a data-tier application HYPERLINK \l "z10" <4>. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190592" [MSDN-CPRTS].
The following is the XML schema definition of the RE: SpatialIndex element.
2.2.17 Statistics
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
The RE:Statistics element specifies the metadata of stored procedure in a data-tier application HYPERLINK \l "z12" <5>. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190592" [MSDN-CPRTS].
The following is the XML schema definition of the RE:Statistics element.
2.2.18 StoredProcedure
The RE:StoredProcedure element specifies the metadata of stored procedure in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190592" [MSDN-CPRTS].
The following is the XML schema definition of the RE:StoredProcedure element.
2.2.19 Synonym
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
The RE:Synonym element specifies the metadata of a stored procedure in a data-tier application HYPERLINK \l "z14" <6>. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190592" [MSDN-CPRTS].
The following is the XML schema definition of the RE:Synonym element.
2.2.20 Table
The RE:Table element specifies the metadata of a table in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190580" [MS-CTTS].
The following is the XML schema definition of the RE:Table element.
2.2.21 TableParameter
The RE:TableParameter element specifies the metadata of a parameter with a table value type in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190595" [MSDN-TVPDE].
The following is the XML schema definition of the RE:TableParameter element.
2.2.22 TableValuedFunction
The RE:TableValueFunction element specifies the metadata of a function that returns a table value in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190606" [MSDN-TVUDF].
The following is the XML schema definition of the RE:TableValueFunction element.
2.2.23 UniqueConstraint
The RE:UniqueConstraint element specifies the metadata of a unique constraint in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190581" [MSDN-CNSTS].
The following is the XML schema definition of the RE:UniqueConstraint element.
2.2.24 User
The RE:User element specifies the metadata of database user in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190596" [MSDN-CUTS].
The following is the XML schema definition of the RE:User element for version 2009/08.
2.2.25 UserDefinedDataType
The RE:UserDefinedDataType element specifies the metadata of a user-defined data type in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190597" [MSDN-DTTS] and HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190599" [MSDN-CTYTS].
The following is the XML schema definition of the RE:UserDefinedDataType element.
2.2.26 UserDefinedTableType
The RE:UserDefinedTableType element specifies the metadata of a user-defined table type in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190600" [MSDN-UDTT] and HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190599" [MSDN-CTYTS].
The following is the XML schema definition of the RE:UserDefinedTableType element.
2.2.27 View
The RE:View element specifies the metadata of a view in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190601" [MSDN-CVTS].
The following is the XML schema definition of the RE:View element.
2.2.28 ActivationOrder
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
RE:ActivationOrder is a simple type for a Boolean type in a data-tier application.
The following is the XML schema definition of the RE:ActivationOrder simple type.
2.2.29 BooleanType
RE:BooleanType is a simple type for a Boolean type in a data-tier application.
The following is the XML schema definition of the RE:BooleanType simple type.
2.2.30 CompatibilityLevelEnumeration
RE:CompatibilityLevelEnumeration is a simple type that enumerates the database compatibility values in a data-tier application.
The following is the XML schema definition of RE:CompatibilityLevelEnumeration for version 2009/08.
2.2.31 DMLActionEnumeration
RE:DMLActionEnumeration is a simple type that enumerates data manipulation language (DML) actions in a data-tier application.
The following is the XML schema definition of the RE:DMLActionEnumeration simple type.
2.2.32 ExecuteAsEnumeration
RE:ExecuteAsEnumeration is a simple type that enumerates EXECUTE AS clause values in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190602" [MSDN-EATS].
The following is the XML schema definition of the RE:ExecuteAsEnumeration simple type for version 2009/08.
The following is the XML schema definition of the RE:ExecuteAsEnumeration simple type for version 2011/03.
2.2.33 GridDensity
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
RE:GridDensity is a simple type that enumerates type of logins in a data-tier application HYPERLINK \l "z16" <7>. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190589" [MSDN-CLTS].
The following is the XML schema definition of the RE:GridDensity simple type.
2.2.34 LoginTypeEnumeration
RE:LoginTypeEnumeration is a simple type that enumerates type of logins in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190589" [MSDN-CLTS].
The following is the XML schema definition of the RE:LoginTypeEnumeration simple type.
2.2.35 PermissionStateEnum
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
RE:PermissionStateEnum is a simple type that enumerates type of logins in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190589" [MSDN-CLTS].
The following is the XML schema definition of the RE:PermissionStateEnum simple type.
2.2.36 PermissionTypeEnum
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
RE:PermissionTypeEnum is a simple type that enumerates type of logins in a data-tier application. For more information, see HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190589" [MSDN-CLTS].
The following is the XML schema definition of the RE:PermissionTypeEnum simple type.
2.2.37 SortOrderEnumeration
RE:SortOrderEnumeration is a simple type that enumerates sort-order values in a data-tier application.
The following is the XML schema definition of the RE:SortOrderEnumeration simple type.
2.2.38 UserTypeEnumeration
Applies to DACPAC XSD version 2009/08 and 2011/03
RE:UserTypeEnumeration is a simple type that enumerates the types of HYPERLINK "[MS-GLOS].pdf" database users in a data-tier application.
The following is the XML schema definition of RE:UserTypeEnumeration simple type for version 2009/08.
2.2.39 FillFactorType
RE:FillFactorType is a simple type that sets the value range of fill factor in a data-tier application.
The following is the XML schema definition of the RE:FillFactorType simple type.
2.2.40 MaxDopType
Applies to DACPAC version 2009/08 only HYPERLINK \l "z6fee9d13c3744d6e8b7c63e96988a7ea" [MSFT-REDACPAC200908]
RE:MaxDopType is a simple type that sets the value range of the maximum degree of parallelism in a data-tier application HYPERLINK \l "z18" <8>. Note that -1 is used if the maxdop value is not set.
The following is the XML schema definition of the RE:MaxDopType simple type.
2.2.41 BaseSystemDataType
RE:BaseSystemDataType is a complex type for the system data type that is described in HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190597" [MSDN-DTTS].
The following is the XML schema definition of the RE:BaseSystemDataType complex type.
2.2.42 CollationType
RE:CollationType is a complex type definition that specifies the collation value in a data-tier application.
The following is the XML schema definition of the RE:CollationTypecomplex type.
2.2.43 ComputedColumnType
RE:ComputedColumnType is a complex type that specifies a computed column in a data-tier application.
The following is the XML schema definition of the RE:ComputedColumnType complex type.
2.2.44 DatabasePermission
RE:DatabasePermission is a complex type that specifies a computed column in a data-tier application HYPERLINK \l "z20" <9>.
The following is the XML schema definition of the RE:DatabasePermission complex type.
2.2.45 DataType
Applies to DACPAC version HYPERLINK \l "z6fee9d13c3744d6e8b7c63e96988a7ea" [MSFT-DACPACRE200908] and DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
RE:DataType is a complex type that specifies all supported data types in a data-tier application.
The following is the XML schema definition of the RE:DataType complex type for version 2008/09 [MSFT-DACPACRE200908].
The following is the XML schema definition of the RE:DataType complex type for 2011/03 [MSFT-REDACPAC201103].
2.2.46 ExecutionContextType
RE:ExecutionContextType is a complex type that specifies the execution context in the EXECUTE AS clause in a data-tier application.
The following is the XML schema definition of the RE:ExecutionContextType complex type.
2.2.47 IdentityType
Applies to DACPAC version 2009/08 HYPERLINK \l "z6fee9d13c3744d6e8b7c63e96988a7ea" [MSFT-REDACPAC200908] and 2011/11 HYPERLINK \l "z83e07328cbaa46da9cc7b4e6cf65348e" [MSFT-REDACPAC201111]
RE:IdentityType is a complex type that specifies the IDENTITY column in a data-tier application.
The following is the [2009/08] XML schema definition of the RE:IdentityType complex type [MSFT-REDACPAC200908].
The following is the [2011/11] XML schema definition of the RE:IdentityType complex type [MSFT-REDACPAC201111]. This definition adds the NotForReplication option property.
2.2.48 Permissions
Applies to DACPAC version 2011/03 HYPERLINK \l "z94a04d8db8c24bc7a40fd7e2208b27f4" [MSFT-REDACPAC201103]
RE:Permissions is a complex type that specifies a scalar-valued data type in a data-tier application HYPERLINK \l "z22" <10>.
The following is the XML schema definition of the RE:Permissions complex type.
2.2.49 ScalarDataType
RE:ScalarDataType is a complex type that specifies a scalar-valued data type in a data-tier application.
The following is the XML schema definition of the RE:ScalarDataType complex type.
2.2.50 SqlDataType
RE:SqlDataType is a complex type that specifies a common structure of data types in a data-tier application.
The following is the XML schema definition of the RE:SqlDataType complex type.
3 Structure Examples
This section provides a sample XML in a data-tier application. A data-tier application consists of logicalobjectstream.xml and physicalobjectstream.xml to specify its management and relational engine model. The following sample consists of a subset of the pubs database to demonstrate the simple usage of a data-tier application. The pubs database can be downloaded from HYPERLINK "http://go.microsoft.com/fwlink/?LinkId=190583" [MSFT-SSPS].
3.1 Pubs database (simplified)
The sample data-tier application XML creates [pubs] database with following objects.
[ p u b s ] d a t a b a s e
[ e m p l o y e e ] t a b l e i n [ d b o ] s c h e m a a n d i t s c o l u m n s
[ e m p i d ] u s e r - d e f i n e d d a t a t y p e
P r i m a r y K e y o n [ e m p _ i d ] c o l u m n
D e f a u l t C o n s t r a i n t o n [ j o b _ i d ] c o l u m n
3 . 2 L o g i c a l o b j e c t s a m p l e
<