How does SQL Compare handle tables with CDC enabled
lwulfers
Posts: 2 Bronze 1
We are using a database that has tables with CDC - Change Data Capture turned on. This feature has issues when you change columns in table with this feature turned on. How does SQL Compare handle tables with CDC - Change Data Capture enabled?
Comments
Thanks for contacting us!
The tool does not support deploying schema changes to CDC enabled objects, so you would need to deploy those changes manually.
Some customers have found that setting up a Filter to filter out those tables helps for more automated deployments of the other objects. https://documentation.red-gate.com/display/SC12/Using+filters
If you are using SQL Source Control, then a Migration Script may help in deploying those types of manual changes https://documentation.red-gate.com/display/SOC5/Working+with+migration+scripts
I hope that helps and do let me know if you have any questions or issues with that!
Warmly,
Technical Sales Engineer
Redgate Software