SqlPackage.exe

/TargetFile:{string}

/tf:{string}

Y

Specifies a disk file path where the .dacpac file will be written.

/p:DacApplicationDescription={ string }

N/A

Defines the Application description to be stored in the DACPAC metadata.

/p:DacApplicationName={ string }

N/A

Defined the Application name to be stored in the DACPAC metadata. The default value is the database name.

/p:DacMajorVersion={integer}

1

Defines the major version to be stored in the DACPAC metadata.

/p:DacMinorVersion={integer}

0

If true, only extract application-scoped objects for the specified source. If false, extract all objects for the specified source.

/p:ExtractApplicationScopedObjectsOnly={True | False}

True

If true, only extract application-scoped objects for the specified source. If false, extract all objects for the specified source.

/p:ExtractReferencedServerScopedElements={True| False}

True

If true, extract login, server audit and credential objects referenced by source database objects.

/p:IgnoreExtendedProperties={True | False}

False

Specifies whether extended properties should be ignored.

/p:IgnorePermissions={True | False}

True

Specifies whether permissions should be ignored.

/p:IgnoreUserLoginMappings={True | False}

False

Specifies whether relationships between users and logins will be ignored.

/p:Storage={File|Memory}

File

Specifies the type of backing storage for the schema model used during extraction.

/p:VerifyExtraction={True | False}

False

Specifies whether the extracted dacpac should be verified.

/Profile:{string}

/pr:{string}

N/A

Specifies the file path to a DAC Publish Profile. The profile defines a collection of properties and variables to use when generating outputs.

/Properties:{PropertyName}={Value}

/p:{PropertyName}={Value}

N/A

Specifies a name value pair for an action specific property; {PropertyName}={Value}. Refer to the help for a specific action to see that action's property names.

/p:AllowDropBlockingAssemblies ={True | False}

False

Specifies whether SqlClr publishing drops blocking assemblies as part of the deployment plan. By default, any blocking or referencing assemblies block an assembly update if the referencing assembly must be dropped.

/p:AllowIncompatiblePlatform={True | False}

False

Specifies whether the publish action should go forward despite potentially incompatible SQL Server platforms.

/p:BackupDatabaseBeforeChanges={True | False}

False

Backups the database before deploying any changes.

/p:BlockOnPossibleDataLoss={True | False}

True

Specifies whether the publish episode is terminated if the publish operation might cause data loss.

/p:BlockWhenDriftDetected={True | False}

True

Specifies whether to block updating a database whose schema no longer matches its registration or is unregistered.

/p:CommentOutSetVarDeclarations={True | False}

False

Specifies whether SETVAR variable declarations are commented out in the generated publish script. You might choose to do this if you plan to use a tool such as SQLCMD.EXE to specify the values on the command line when you publish.

/p:CompareUsingTargetCollation={True | False}

False

This setting dictates how the database's collation is handled during deployment; by default the target database's collation will be updated if it does not match the collation specified by the source. When this option is set, the target database's (or server's) collation should be used.

/p:CreateNewDatabase={True | False}

False

Specifies whether the target database should be updated or whether it should be dropped and re-created when you publish to a database.

/p:DeployDatabaseInSingleUserMode={True | False}

False

If true, the database is set to Single User Mode before deploying.

/p:DisableAndReenableDdlTriggers={True | False}

True

Specifies whether Data Definition Language (DDL) triggers are disabled at the beginning of the publish process and re-enabled at the end of the publish action.

/p:DoNotAlterChangeDataCaptureObjects={True | False}

True

If true, Change Data Capture objects are not altered.

/p:DoNotAlterReplicatedObjects={True | False}

True

Specifies whether objects that are replicated are identified during verification.

/p:DropConstraintsNotInSource={True | False}

True

Specifies whether the publish action drops constraints that do not exist in the database snapshot (.dacpac) from the target database when you publish to a database.

/p:DropDmlTriggersNotInSource={True | False}

True

Specifies whether the publish action drops Data Manipulation Language (DML) triggers that do not exist in the database snapshot (.dacpac) from the target database when you publish to a database.

/p:DropExtendedPropertiesNotInSource={True | False}

True

Specifies whether the publish action drops extended properties that do not exist in the database snapshot (.dacpac) from the target database when you publish to a database.

/p:DropIndexesNotInSource={True | False}

True

Specifies whether the publish action drops indexes that do not exist in the database snapshot (.dacpac) from the target database when you publish to a database.

/p:DropObjectsNotInSource={True | False}

False

Specifies whether objectsthat do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropPermissionsNotInSource={True | False}

False

Specifies whether the publish action permissions that do not exist in the database snapshot (.dacpac) from the target database when you publish to a database.

/p:DropRoleMembersNotInSource={True | False}

False

Specifies whether the publish action drops role members that do not exist in the database snapshot (.dacpac) from the target database when you publish to a database.

/p:GenerateSmartDefaults={True | False}

False

Specifies whether SqlPackage.exe provides a default value automatically when it updates a table that contains data with a column that does not allow null values.

/p:IgnoreAnsiNulls={True | False}

False

Specifies whether to ignore or update differences in the ANSI NULLS setting when you publish to a database.

/p: IgnoreAuthorizer={True | False}

False

Specifies whether to ignore or update differences in the Authorizer when you publish to a database.

/p:IgnoreColumnCollation={True | False}

False

Specifies whether to ignore or update differences in column collation when you publish to a database.

/p:IgnoreComments={True | False}

False

Specifies whether to ignore or update differences in comments order when you publish to a database.

/p:IgnoreCryptographicProviderFile={True | False}

True

Specifies whether to ignore or update differences in the file path for a cryptographic provider when you publish to a database.

/p:IgnoreDdlTriggerOrder={True | False}

False

Specifies whether to ignore or update differences in the order of Data Definition Language (DDL) triggers when you publish to a database.

/p:IgnoreDdlTriggerState={True | False}

False

Specifies whether to ignore or update differences in the enabled or disabled state of DDL triggers when you publish to a database.

/p:IgnoreDefaultSchema={True | False}

False

Specifies whether to ignore or update differences in the default schema when you publish to a database.

/p:IgnoreDmlTriggerOrder={True | False}

False

Specifies whether to ignore or update differences in the order of DML triggers when you publish to a database.

/p:IgnoreDmlTriggerState={True | False}

False

Specifies whether to ignore or update differences in the enabled or disabled state of DML triggers when you publish to a database.

/p:IgnoreExtendedProperties={True | False}

False

Specifies whether to ignore or update differences in extended properties when you publish to a database.

/p:IgnoreFileAndLogFilePath={True | False}

True

Specifies whether to ignore or update differences in the paths for files and log files when you publish to a database.

/p:IgnoreFilegroupPlacement={True | False}

True

Specifies whether to ignore or update differences in the placement of FILEGROUPs when you publish to a database.

/p:IgnoreFileSize={True | False}

True

Specifies whether to ignore or update differences in file sizes when you publish to a database.

/p:IgnoreFillFactor={True | False}

True

Specifies whether to ignore or update differences in fill factors when you publish to a database.

/p:IgnoreFullTextCatalogFilePath={True | False}

True

Specifies whether to ignore or update differences in the path to full-text index files when you publish to a database.

/p:IgnoreIdentitySeed={True | False}

False

Specifies whether to ignore or update differences in the seed for an identity column when you publish to a database.

/p:IgnoreIncrement={True | False}

False

Specifies whether to ignore or update differences in the increment for an identity column when you publish to a database.

/p:IgnoreIndexOptions={True | False}

False

Specifies whether to ignore or update differences in the index options when you publish to a database.

/p:IgnoreIndexPadding={True | False}

True

Specifies whether to ignore or update differences in the index padding when you publish to a database.

/p:IgnoreKeywordCasing={True | False}

True

Specifies whether to ignore or update differences in the keyword casing when you publish to a database.

/p:IgnoreLockHintsOnIndexes={True | False}

False

Specifies whether to ignore or update differences in the lock hints on indexes when you publish to a database.

/p:IgnoreLoginSids={True | False}

True

Specifies whether to ignore or update differences in the security identifier (SID) when you publish to a database.

/p:IgnoreNotForReplication={True | False}

False

Specifies whether to ignore or update the not-for-replication setting when you publish to a database.

/p:IgnoreObjectPlacementOnPartitionScheme={True | False}

True

Specifies whether to ignore or update an object’s placement on a partition scheme when you publish to a database.

/p:IgnorePartitionSchemes={True | False}

False

Specifies whether to ignore or update differences in partition schemes and functions when you publish to a database.

/p:IgnorePermissions={True | False}

False

Specifies whether to ignore or update differences in permissions when you publish to a database.

/p:IgnoreQuotedIdentifiers={True | False}

False

Specifies whether to ignore or update differences in quoted identifier settings when you publish to a database.

/p:IgnoreRoleMembership={True | False}

False

Specifies whether differences in the role membership of logins should be ignored or updated when you publish to a database.

/p:IgnoreRouteLifetime={True | False}

True

Specifies whether to ignore or update differences in the role memberships of logins when you publish to a database.

/p:IgnoreSemicolonBetweenState={True | False}

True

Specifies whether to ignore or update differences in semicolons between Transact-SQL statements when you publish to a database.

/p:IgnoreTableOptions={True | False}

False

Specifies whether to ignore or update differences in table options when you publish to a database.

/p:IgnoreUserSettingsObjects={True | False}

False

Specifies whether to ignore or update differences in user setting options when you publish to a database.

/p:IgnoreWhitespace={True | False}

True

Specifies whether to ignore or update differences in whitespace when you publish to a database.

/p:IgnoreWithNocheckOnCheckConstraints={True | False}

False

Specifies whether to ignore or update differences in the value of the WITH NOCHECK clause for check constraints when you publish to a database.

/p:IgnoreWithNocheckOnForeignKeys={True | False}

False

Specifies whether to ignore or update differences in the value of the WITH NOCHECK clause for foreign keys when you publish to a database.

/p:IncludeCompositeObjects={True | False}

False

Specifies whether to include all composite elements as part of a single publish operation.

/p:IncludeTransactionalScripts={True | False}

False

Specifies whether to use transactional statements wherever possible when you publish to a database.

/p:NoAlterStatementsToChangeClrTypes={True | False}

False

Specifies that publish should always drop and re-create an assembly if there is a difference instead of issuing an ALTER ASSEMBLY statement.

/p:PopulateFilesOnFilegroups={True | False}

True

Specifies whether a new file is also created when you create a new FileGroup in the target database.

/p:RegisterDataTierApplication={True | False}

False

Specifies whether the schema is registered with the database server.

/p:ScriptDatabaseCollation={True | False}

False

Specifies whether to ignore or update differences in database collation when you publish to a database.

/p:ScriptDatabaseCompatibility={True | False}

True

Specifies whether to ignore or update differences in database compatibility when you publish to a database.

/p:ScriptDatabaseOptions={True | False}

True

Specifies whether to set or update target database properties when you publish to a database.

/p:ScriptFileSize={True | False}

False

Controls whether size is specified when adding a file to a filegroup.

p:ScriptNewConstraintValidation={True | False}

True

Specifies whether to verify all constraints as one set at the end of publishing, avoiding data errors caused by a check or foreign key constraint in the middle of the publish action. If this option is False, constraints are published without checking the corresponding data.

/p:ScriptDeployStateChecks={True | False}

False

Specifies whether to generate statements in the publish script to verify that the database and server names match the names specified in the database project.

/p:ScriptRefreshModule={True | False}

True

Specifies whether to include refresh statements at the end of the publish script.

/p:Storage={File | Memory}

Memory

Specifies how elements are stored when building the database model. For performance reasons the default is InMemory. For very large databases, File backed storage is required.

/p:TreatVerificationErrorsAsWarnings={True | False}

False

Specifies whether to treat errors that occur during publish verification as warnings. The check is performed against the generated deployment plan before the plan is executed against the target database. Plan verification detects problems, such as the loss of target-only objects (for example, indexes), that must be dropped to make a change. Verification also detects situations where dependencies (such as tables or views) exist because of a reference to a composite project, but do not exist in the target database. You might choose to treat verification errors as warnings to get a complete list of issues instead of allowing the publish action to stop when the first error occurs.

/p:UnmodifiableObjectWarnings={True | False}

True

Specifies whether to generate warnings when differences are found in objects that cannot be modified (for example, if the file size or file paths are different for a file).

/p:VerifyCollationCompatibility={True | False}

True

Specifies whether collation compatibility is verified.

/p:VerifyDeployment={True | False}

True

Specifies whether to perform checks before publishing that stop the publish action if issues are present that might block successful publishing. For example, your publish action might stop if you get errors during publishing because foreign keys on the target database do not exist in the database project.

/Variables:{PropertyName}={Value}

Specifies a name value pair for an action specific variable; {VariableName}={Value}. The DACPAC file contains the list of valid SQLCMD variables. An error will result if a value is not provided for every variable.

/OutputPath:{string}

/op:{string}

Y

Specifies the file path where the XML output files are generated.

/p:AllowDropBlockingAssemblies={True | False}

False

This property is used by SqlClr deployment to cause any blocking assemblies to be dropped as part of the deployment plan. By default, any blocking/referencing assemblies will block an assembly update if the referencing assembly needs to be dropped.

/p:AllowIncompatiblePlatform={True | False}

False

Specifies whether the report action should go forward despite potentially incompatible SQL Server platforms.

/p:BackupDatabaseBeforeChanges={True | False}

False

Backs up the database before deploying any changes.

/p:BlockOnPossibleDataLoss={True | False}

True

Specifies that the publish episode should be terminated if there is a possibility of data loss resulting from the publish. operation.

/p:BlockWhenDriftDetected={True | False}

True

Specifies whether to block updating a database whose schema no longer matches its registration or is unregistered.

/p:CommentOutSetVarDeclarations={True | False}

False

Specifies whether the declaration of SETVAR variables should be commented out in the generated publish script. You might choose to do this if you plan to specify the values on the command line when you publish by using a tool such as SQLCMD.EXE.

/p:CompareUsingTargetCollation={True | False}

False

This setting dictates how the database's collation is handled during deployment; by default the target database's collation will be updated if it does not match the collation specified by the source. When this option is set, the target database's (or server's) collation should be used.

/p:CreateNewDatabase={True | False}

False

Specifies whether the target database should be updated or whether it should be dropped and re-created when you publish to a database.

/p:DeployDatabaseInSingleUserMode={True | False}

False

If true, the database is set to Single User Mode before deploying.

/p:DisableAndReenableDdlTriggers={True | False}

True

Specifies whether Data Definition Language (DDL) triggers are disabled at the beginning of the publish process and re-enabled at the end of the publish action.

/p:DoNotAlterChangeDataCaptureObjects={True | False}

False

If true, Change Data Capture objects are not altered.

/p:DoNotAlterReplicatedObjects={True | False}

True

Specifies whether objects that are replicated are identified during verification.

/p:DropConstraintsNotInSource={True | False}

True

Specifies whether constraints that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropDmlTriggersNotInSource={True | False}

True

Specifies whether DML triggers that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropExtendedPropertiesNotInSource={True | False}

True

Specifies whether extended properties that do not exist in the databasesnapshot (.dacpac) file will be dropped from the target database when youpublish to a database.

/p:DropIndexesNotInSource={True | False}

True

Specifies whether indexes that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropObjectsNotInSource={True | False}

False

Specifies whether objectsthat do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropPermissionsNotInSource={True | False}

False

Specifies whether permissions that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.

/p:DropRoleMembersNotInSource={True | False}

False

Specifies whether role members that are not defined in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.

/p:GenerateSmartDefaults={True | False}

False

Automatically provides a default value when updating a table that contains data with a column that does not allow null values.

/p:IgnoreAnsiNulls={True | False}

False

Specifies whether to ignore or update differences in the ANSI NULLS setting when you publish to a database.

/p: IgnoreAuthorizer={True | False}

False

Specifies whether to ignore or update differences in the Authorizer when you publish to a database.

/p:IgnoreColumnCollation={True | False}

False

Specifies whether to ignore or update differences in column collation when you publish to a database.

/p:IgnoreComments={True | False}

False

Specifies whether to ignore or update differences in comments order when you publish to a database.

/p:IgnoreCryptographicProviderFile={True | False}

True

Specifies whether to ignore or update differences in the file path for a cryptographic provider when you publish to a database.

/p:IgnoreDdlTriggerOrder={True | False}

False

Specifies whether to ignore or update differences in the order of Data Definition Language (DDL) triggers when you publish to a database.

/p:IgnoreDdlTriggerState={True | False}

False

Specifies whether to ignore or update differences in the enabled or disabled state of DDL triggers when you publish to a database.

/p:IgnoreDefaultSchema={True | False}

False

Specifies whether to ignore or update differences in the default schema when you publish to a database.

/p:IgnoreDmlTriggerOrder={True | False}

False

Specifies whether to ignore or update differences in the order of DML triggers when you publish to a database.

/p:IgnoreDmlTriggerState={True | False}

False

Specifies whether to ignore or update differences in the enabled or disabled state of DML triggers when you publish to a database.

/p:IgnoreExtendedProperties={True | False}

False

Specifies whether to ignore or update differences in extended properties when you publish to a database.

/p:IgnoreFileAndLogFilePath={True | False}

True

Specifies whether to ignore or update differences in the paths for files and log files when you publish to a database.

/p:IgnoreFilegroupPlacement={True | False}

True

Specifies whether to ignore or update differences in the placement of FILEGROUPs when you publish to a database.

/p:IgnoreFileSize={True | False}

True

Specifies whether to ignore or update differences in file sizes when you publish to a database.

/p:IgnoreFillFactor={True | False}

True

Specifies whether to ignore or update differences in fill factors when you publish to a database.

/p:IgnoreFullTextCatalogFilePath={True | False}

True

Specifies whether to ignore or update differences in the path to full-text index files when you publish to a database.

/p:IgnoreIdentitySeed={True | False}

False

Specifies whether to ignore or update differences in the seed for an identity column when you publish to a database.

/p:IgnoreIncrement={True | False}

False

Specifies whether to ignore or update differences in the increment for an identity column when you publish to a database.

/p:IgnoreIndexOptions={True | False}

False

Specifies whether to ignore or update differences in the index options when you publish to a database.

/p:IgnoreIndexPadding={True | False}

True

Specifies whether to ignore or update differences in the index padding when you publish to a database.

/p:IgnoreKeywordCasing={True | False}

True

Specifies whether to ignore or update differences in the keyword casing when you publish to a database.

/p:IgnoreLoginSids={True | False}

True

Specifies whether to ignore or update differences in the security identifier (SID) when you publish to a database.

/p:IgnoreNotForReplication={True | False}

False

Specifies whether to ignore or update the not-for-replication setting when you publish to a database.

/p:IgnoreObjectPlacementOnPartitionScheme={True | False}

True

Specifies whether to ignore or update an object’s placement on a partition scheme when you publish to a database.

/p:IgnorePartitionSchemes={True | False}

False

Specifies whether to ignore or update differences in partition schemes and functions when you publish to a database.

/p:IgnorePermissions={True | False}

False

Specifies whether to ignore or update differences in permissions when you publish to a database.

/p:IgnoreQuotedIdentifiers={True | False}

False

Specifies whether to ignore or update differences in quoted identifier settings when you publish to a database.

/p:IgnoreRoleMembership={True | False}

False

Specifies whether differences in the role membership of logins should be ignored or updated when you publish to a database.

/p:IgnoreRouteLifetime={True | False}

True

Specifies whether to ignore or update differences in the role memberships of logins when you publish to a database.

/p:IgnoreSemicolonBetweenState={True | False}

True

Specifies whether to ignore or update differences in semicolons between Transact-SQL statements when you publish to a database.

/p:IgnoreTableOptions={True | False}

False

Specifies whether to ignore or update differences in table options when you publish to a database.

/p:IgnoreUserSettingsObjects={True | False}

False

Specifies whether to ignore or update differences in user setting options when you publish to a database.

/p:IgnoreWhitespace={True | False}

True

Specifies whether to ignore or update differences in whitespace when you publish to a database.

/p:IgnoreWithNocheckOnCheckConstraints={True | False}

False

Specifies whether to ignore or update differences in the value of the WITH NOCHECK clause for check constraints when you publish to a database.

/p:IgnoreWithNocheckOnForeignKeys={True | False}

False

Specifies whether to ignore or update differences in the value of the WITH NOCHECK clause for foreign keys when you publish to a database.

/p:IncludeCompositeObjects={True | False}

False

Specifies whether to include all composite elements as part of a single publish operation.

/p:IncludeTransactionalScripts={True | False}

False

Specifies whether to use transactional statements wherever possible when you publish to a database.

/p:NoAlterStatementsToChangeClrTypes={True | False}

False

Specifies that publish should always drop and re-create an assembly if there is a difference instead of issuing an ALTER ASSEMBLY statement.

/p:PopulateFilesOnFilegroups={True | False}

True

Specifies whether a new file is also created when you create a new FileGroup in the target database.

/p:RegisterDataTierApplication={True | False}

False

Specifies whether the schema is registered with the database server.

/p:ScriptDatabaseCollation={True | False}

False

Specifies whether to ignore or update differences in database collation when you publish to a database.

/p:ScriptDatabaseCompatibility={True | False}

True

Specifies whether to ignore or update differences in database compatibility when you publish to a database.

/p:ScriptDatabaseOptions={True | False}

True

Specifies whether to set or update target database properties when you publish to a database.

/p:ScriptFileSize={True | False}

False

Controls whether size is specified when adding a file to a filegroup.

/p:ScriptNewConstraintValidation={True | False}

True

Specifies whether to verify all constraints as one set at the end of publishing, avoiding data errors caused by a check or foreign key constraint in the middle of the publish action. If this option is False, constraints are published without checking the corresponding data.

/p:ScriptDeployStateChecks={True | False}

False

Specifies whether to generate statements in the publish script to verify that the database and server names match the names specified in the database project.

/p:ScriptRefreshModule={True | False}

True

Specifies whether to include refresh statements at the end of the publish script.

/p:Storage={File | Memory}

Memory

Specifies how elements are stored when building the database model. For performance reasons the default is InMemory. For very large databases, File backed storage is required.

/p:TreatVerificationErrorsAsWarnings={True | False}

False

Specifies whether to treat errors that occur during publish verification as warnings. The check is performed against the generated deployment plan before the plan is executed against the target database. Plan verification detects problems, such as the loss of target-only objects (for example, indexes), that must be dropped to make a change. Verification also detects situations where dependencies (such as tables or views) exist because of a reference to a composite project, but do not exist in the target database. You might choose to treat verification errors as warnings to get a complete list of issues instead of allowing the publish action to stop when the first error occurs.

/p:UnmodifiableObjectWarnings={True | False}

True

Specifies whether to generate warnings when differences are found in objects that cannot be modified (for example, if the file size or file paths are different for a file).

/p:VerifyCollationCompatibility={True | False}

True

Specifies whether collation compatibility is verified.

/p:VerifyDeployment={True | False}

True

Specifies whether to perform checks before publishing that stop the publish action if issues are present that might block successful publishing. For example, your publish action might stop if you get errors during publishing because foreign keys on the target database do not exist in the database project.

/OutputPath:{string}

/op:{string}

Y

Specifies the file path where the output files are generated.

/p:AllowDropBlockingAssemblies={True | False}

False

This property is used by SqlClr deployment to cause any blocking assemblies to be dropped as part of the deployment plan. By default, any blocking/referencing assemblies will block an assembly update if the referencing assembly needs to be dropped.

/p:AllowIncompatiblePlatform={True | False}

False

Specifies whether the report action should go forward despite potentially incompatible SQL Server platforms.

/p:BackupDatabaseBeforeChanges={True | False}

False

Backs up the database before deploying any changes.

/p:BlockOnPossibleDataLoss={True | False}

True

Specifies that the publish episode should be terminated if there is a possibility of data loss resulting from the publish operation.

/p:BlockWhenDriftDetected={True | False}

True

Specifies whether to block updating a database whose schema no longer matches its registration or is unregistered.

/p:CommentOutSetVarDeclarations={True | False}

False

Specifies whether the declaration of SETVAR variables should be commented out in the generated publish script. You might choose to do this if you plan to specify the values on the command line when you publish by using a tool such as SQLCMD.EXE.

/p:CompareUsingTargetCollation={True | False}

False

This setting dictates how the database's collation is handled during deployment; by default the target database's collation will be updated if it does not match the collation specified by the source. When this optionis set, the target database's (or server's) collation should be used.

/p:CreateNewDatabase={True | False}

False

Specifies whether the target database should be updated or whether it should be dropped and re-created when you publish to a database.

/p:DeployDatabaseInSingleUserMode={True | False}

False

If true, the database is set to Single User Mode before deploying.

/p:DisableAndReenableDdlTriggers={True | False}

True

Specifies whether Data Definition Language (DDL) triggers are disabled at the beginning of the publish process and re-enabled at the end of the publish action.

/p:DoNotAlterChangeDataCaptureObjects={True | False}

True

If true, Change Data Capture objects are not altered.

/p:DoNotAlterReplicatedObjects={True | False}

True

Specifies whether objects that are replicated are identified during verification.

/p:DropConstraintsNotInSource={True | False}

True

Specifies whether constraints that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropDmlTriggersNotInSource={True | False}

True

Specifies whether DML triggers that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropExtendedPropertiesNotInSource={True | False}

True

Specifies whether extended properties that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropIndexesNotInSource={True | False}

True

Specifies whether indexes that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropObjectsNotInSource={True | False}

False

Specifies whether objects that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.

/p:DropPermissionsNotInSource={True | False}

False

Specifies whether permissions that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.

/p:DropRoleMembersNotInSource={True | False}

False

Specifies whether role members that are not defined in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.

/p:GenerateSmartDefaults={True | False}

False

Automatically provides a default value when updating a table that contains data with a column that does not allow null values.

/p:IgnoreAnsiNulls={True | False}

False

Specifies whether to ignore or update differences in the ANSI NULLS setting when you publish to a database.

/p: IgnoreAuthorizer={True | False}

False

Specifies whether to ignore or update differences in the Authorizer when you publish to a database.

/p:IgnoreColumnCollation={True | False}

False

Specifies whether to ignore or update differences in column collation when you publish to a database.

/p:IgnoreComments={True | False}

False

Specifies whether to ignore or update differences in comments order when you publish to a database.

/p:IgnoreCryptographicProviderFile={True | False}

True

Specifies whether to ignore or update differences in the file path for a cryptographic provider when you publish to a database.

/p:IgnoreDdlTriggerOrder={True | False}

False

Specifies whether to ignore or update differences in the order of Data Definition Language (DDL) triggers when you publish to a database.

/p:IgnoreDdlTriggerState={True | False}

False

Specifies whether to ignore or update differences in the enabled or disabled state of DDL triggers when you publish to a database.

/p:IgnoreDefaultSchema={True | False}

False

Specifies whether to ignore or update differences in the default schema when you publish to a database.

/p:IgnoreDmlTriggerOrder={True | False}

False

Specifies whether to ignore or update differences in the order of DML triggers when you publish to a database.

/p:IgnoreDmlTriggerState={True | False}

False

Specifies whether to ignore or update differences in the enabled or disabled state of DML triggers when you publish to a database.

/p:IgnoreExtendedProperties={True | False}

False

Specifies whether to ignore or update differences in extended properties when you publish to a database.

/p:IgnoreFileAndLogFilePath={True | False}

True

Specifies whether to ignore or update differences in the paths for files and log files when you publish to a database.

/p:IgnoreFilegroupPlacement={True | False}

True

Specifies whether to ignore or update differences in the placement of FILEGROUPs when you publish to a database.

/p:IgnoreFileSize={True | False}

True

Specifies whether to ignore or update differences in file sizes when you publish to a database.

/p:IgnoreFillFactor={True | False}

True

Specifies whether to ignore or update differences in fill factors when you publish to a database.

/p:IgnoreFullTextCatalogFilePath={True | False}

True

Specifies whether to ignore or update differences in the path to full-text index files when you publish to a database.

/p:IgnoreIdentitySeed={True | False}

False

Specifies whether to ignore or update differences in the seed for an identity column when you publish to a database.

/p:IgnoreIncrement={True | False}

False

Specifies whether to ignore or update differences in the increment for an identity column when you publish to a database.

/p:IgnoreIndexOptions={True | False}

False

Specifies whether to ignore or update differences in the index options when you publish to a database.

/p:IgnoreIndexPadding={True | False}

True

Specifies whether to ignore or update differences in the index padding when you publish to a database.

/p:IgnoreKeywordCasing={True | False}

True

Specifies whether to ignore or update differences in the keyword casing when you publish to a database.

/p:IgnoreLoginSids={True | False}

True

Specifies whether to ignore or update differences in the security identifier (SID) when you publish to a database.

/p:IgnoreLockHintsOnIndexes={True | False}

False

Specifies whether differences in the lock hints on indexes should be ignored or updated when you publish to a database.

/p:IgnoreNotForReplication={True | False}

False

Specifies whether to ignore or update the not-for-replication setting when you publish to a database.

/p:IgnoreObjectPlacementOnPartitionScheme={True | False}

True

Specifies whether to ignore or update an object’s placement on a partition scheme when you publish to a database.

/p:IgnorePartitionSchemes={True | False}

False

Specifies whether to ignore or update differences in partition schemes and functions when you publish to a database.

/p:IgnorePermissions={True | False}

False

Specifies whether to ignore or update differences in permissions when you publish to a database.

/p:IgnoreQuotedIdentifiers={True | False}

False

Specifies whether to ignore or update differences in quoted identifier settings when you publish to a database.

/p:IgnoreRoleMembership={True | False}

False

Specifies whether differences in the role membership of logins should be ignored or updated when you publish to a database.

/p:IgnoreRouteLifetime={True | False}

True

Specifies whether to ignore or update differences in the role memberships of logins when you publish to a database.

/p:IgnoreSemicolonBetweenState={True | False}

True

Specifies whether to ignore or update differences in semicolons between Transact-SQL statements when you publish to a database.

/p:IgnoreTableOptions={True | False}

False

Specifies whether to ignore or update differences in table options when you publish to a database.

/p:IgnoreUserSettingsObjects={True | False}

False

Specifies whether to ignore or update differences in user setting options when you publish to a database.

/p:IgnoreWhitespace={True | False}

True

Specifies whether to ignore or update differences in whitespace when you publish to a database.

/p:IgnoreWithNocheckOnCheckConstraints={True | False}

False

Specifies whether to ignore or update differences in the value of the WITH NOCHECK clause for check constraints when you publish to a database.

/p:IgnoreWithNocheckOnForeignKeys={True | False}

False

Specifies whether to ignore or update differences in the value of the WITH NOCHECK clause for foreign keys when you publish to a database.

/p:IncludeCompositeObjects={True | False}

False

Specifies whether to include all composite elements as part of a single publish operation.

/p:IncludeTransactionalScripts={True | False}

False

Specifies whether to use transactional statements wherever possible when you publish to a database.

/p:NoAlterStatementsToChangeClrTypes={True | False}

False

Specifies that publish should always drop and re-create an assembly if there is a difference instead of issuing an ALTER ASSEMBLY statement.

/p:PopulateFilesOnFilegroups={True | False}

True

Specifies whether a new file is also created when you create a new FileGroup in the target database.

/p:RegisterDataTierApplication={True | False}

False

Specifies whether the schema is registered with the database server.

/p:ScriptDatabaseCollation={True | False}

False

Specifies whether to ignore or update differences in database collation when you publish to a database.

/p:ScriptDatabaseCompatibility={True | False}

True

Specifies whether to ignore or update differences in database compatibility when you publish to a database.

/p:ScriptDatabaseOptions={True | False}

True

Specifies whether to set or update target database properties when you publish to a database.

/p:ScriptFileSize={True | False}

False

Controls whether size is specified when adding a file to a filegroup.

/p:ScriptNewConstraintValidation={True | False}

True

Specifies whether to verify all constraints as one set at the end of publishing, avoiding data errors caused by a check or foreign key constraint in the middle of the publish action. If this option is False, constraints are published without checking the corresponding data.

/p:ScriptDeployStateChecks={True | False}

False

Specifies whether to generate statements in the publish script to verify that the database and server names match the names specified in the database project.

/p:ScriptRefreshModule={True | False}

True

Specifies whether to include refresh statements at the end of the publish script.

/p:Storage={File | Memory}

Memory

Specifies how elements are stored when building the database model. For performance reasons the default is InMemory. For very large databases, File backed storage is required.

/p:TreatVerificationErrorsAsWarnings={True | False}

False

Specifies whether to treat errors that occur during publish verification as warnings. The check is performed against the generated deployment plan before the plan is executed against the target database. Plan verification detects problems, such as the loss of target-only objects (for example, indexes), that must be dropped to make a change. Verification also detects situations where dependencies (such as tables or views) exist because of a reference to a composite project, but do not exist in the target database. You might choose to treat verification errors as warnings to get a complete list of issues instead of allowing the publish action to stop when the first error occurs.

/p:UnmodifiableObjectWarnings={True | False}

True

Specifies whether warnings should be generated when differences are found in objects that cannot be modified, for example, if the file size or file paths were different for a file.

/p:VerifyCollationCompatibility={True | False}

True

Specifies whether collation compatibility is verified.

/p:VerifyDeployment={True | False}

True

Specifies whether checks should be performed before publishing that will stop the publish action if issues are present that might block successful publishing. For example, your publish action might stop if you have foreign keys on the target database that do not exist in the database project, and that will cause errors when you publish.