Red Gate forums :: View topic - Applying changes to a DB under Change Data Capture
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Applying changes to a DB under Change Data Capture

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jahmann



Joined: 01 Dec 2010
Posts: 2

PostPosted: Fri Aug 31, 2012 8:35 pm    Post subject: Applying changes to a DB under Change Data Capture Reply with quote

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.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Sep 03, 2012 7:18 pm    Post subject: Reply with quote

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/141379-sql-compare-feature-suggestions
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group