July 11, 2014 at 6:49 am
Hi,
I have a database project where objects have been pulled in from the database using schema compare. Unfortunately CDC tables which are referenced in stored procedures on the database have not been pulled in by the schema compare & hence I cannot build the project and deploy changes back to the database.
If anyone's got any ideas on how to get these tables included in the project it would be much appreciated.
Thanks
Peter
July 11, 2014 at 8:28 am
I just enabled CDC on a test database to see how it creates the CDC tables. The CDC tables are created as system tables which are ignored by the schema compare, so I think your only option is to manually generate the scripts for the CDC tables in SSMS or use some other process (PoSH) to generate the CDC table scripts and add them manually to the database project.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply