Applying changes to a DB under Change Data Capture

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Applying changes to a DB under Change Data Capture

Postby jahmann » Fri Aug 31, 2012 8:35 pm

Hi - I ran into a problem while applying some changes to a Dev database that had CDC enabled on most tables - got an error like this:

Cannot alter column 'CoverageAreaTypeCode' because it is 'enabled for Replication or Change Data Capture'.

I was able to work around these issues, but was wondering:
1 - is there something that I can do in SQL Compare to avoid this problem in the future (it didn't notice I had CDC on in the target), or
2 - are there techniques that I can employ to safely/easily promote changes to a DB that is running CDC ?

I plan on googling for some best practices, but I figured some of you may have already encountered this kind of problem and have some quick advice.
jahmann
 
Posts: 2
Joined: Wed Dec 01, 2010 8:35 pm

Postby Chris Auckland » Mon Sep 03, 2012 7:18 pm

Thanks for your post.

I'm afraid we don't have any specific support to handle cdc enabled databases. I think you would need to disable cdc on the object before you try to deploy the changes with SQL Compare and then turn it on again afterwards.

This might be something that SQL Compare could do as part of the deployment script, so it might be worth logging a feature request for it on our uservoice site:

http://redgate.uservoice.com/forums/141 ... uggestions
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests