Shulou(Shulou.com)06/02 Report--

This article mainly shows you the "SQL Server DACPAC database deployment errors do", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "SQL Server DACPAC database deployment errors how to do" this article.

DACPAC uses sqlpackage.exe for deployment, and an error is reported during deployment:

EXEC: error SQL72035: [dbo]. [table] is under change data capture control and cannot be modified

This error was resolved by adding the following parameters during deployment due to the enabling of cdc.

/ p:DoNotAlterChangeDataCaptureObjects=False

A new error occurred in the deployment after it was added:

EXEC: error SQL72035: [dbo]. [table] is treated as replicated due to change tracking and cannot be modified.

This error is due to the fact that the implementation of cdc is consistent with that of replication, so it is considered to be replicated internally. Continue to add the following parameters to solve the problem:

/ p: DoNotAlterReplicatedObjects false

To sum up, two additional parameters need to be added to deploy through DACPAC when advanced features such as cdc or replication are enabled:

/ p:DoNotAlterChangeDataCaptureObjects=False

/ p: DoNotAlterReplicatedObjects false

These are all the contents of the article "what to do with SQL Server DACPAC database deployment errors". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.