Deployment
Configures generated database objects and deployment artifacts.
Use this page to find the Deployment settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| DACPAC Model Storage Type | DACPAC_MODEL_STORAGE_TYPE | 1 | DACPAC model storage type: 0-File, 1-Memory. |
| Deployment Create Subdirectory | DEPLOYMENT_CREATE_SUBDIRECTORY | 1 | Create a subdirectory for every created deployment package. 0-no (all files in output directory will be deleted), 1-yes. Default - 1. |
| Deployment Do Not Drop Object Types | DEPLOYMENT_DO_NOT_DROP_OBJECT_TYPES | Aggregates,ApplicationRoles,Assemblies,AsymmetricKeys,BrokerPriorities,Certificates,Contracts,DatabaseRoles,DatabaseTriggers,FullTextCatalogs,FullTextStoplists,MessageTypes,PartitionFunctions,PartitionSchemes,Permissions,Queues,RemoteServiceBindings,RoleMembership,Rules,SearchPropertyLists,Sequences,Services,Signatures,SymmetricKeys,Synonyms,UserDefinedDataTypes,UserDefinedTableTypes,ClrUserDefinedTypes,Users,XmlSchemaCollections,Audits,Credentials,CryptographicProviders,DatabaseAuditSpecifications,Endpoints,ErrorMessages,EventNotifications,EventSessions,LinkedServerLogins,LinkedServers,Logins,Routes,ServerAuditSpecifications,ServerRoleMembership,ServerRoles,ServerTriggers | Comma-separated list of object types (see description of SQLPACKAGE.EXE). |
| DWH Metadata In Extended Properties | DWH_METADATA_IN_EXTENDED_PROPERTIES | 1 | Store metadata as extended properties of database objects. |
| Index Compression Type | INDEX_COMPRESSION_TYPE | 1 | Default index compression type in case table compression type is NONE OR COLUMNSTORE INDEX (otherwise indexes will have the same compression type as tables): 1-NONE, 2-PAGE, 3-ROW. |
| Table Compression Type | TABLE_COMPRESSION_TYPE | 1 | Default table compression type: 1-NONE, 2-PAGE, 3-ROW, 4-COLUMNSTORE INDEX. |
