Deployment Do Not Drop Object Types
Overview
Deployment Do Not Drop Object Types is a Deployment parameter that controls the comma-separated list of object types (see the description of SQLPACKAGE.EXE).
Function
Use this setting to keep deployment and generated database artifact creation consistent across the project. AnalyticsCreator uses this value when no custom value is saved for the project.
Access
The parameter is maintained from the Parameters list in AnalyticsCreator.
How to access
Navigation tree
Parameters->List Parameters
Toolbar
Options->Parameter
Diagram
Not opened from the diagram.
Visual element
Parameter list
Default value
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
Custom value
Not set.
Where it is used
This parameter belongs to the Deployment group and is used when AnalyticsCreator applies deployment and generated database artifact creation.
| Setting | Value |
|---|---|
| Technical parameter name | DEPLOYMENT_DO_NOT_DROP_OBJECT_TYPES |
| Default value | 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 |
| Custom value | Not set. |
Parameter groups
| Group |
|---|
| Deployment |
| Database Options |
| Storage |
