How do I sync just the tables that are in source control?
vincentj
Posts: 47
Hi,
I'm trying to use SQL Data Compare to sync my database with the changes in source control as part of a continuous integration system. I'm comparing against a script folder checked out from Subversion. I only want to sync the static tables that are in source control and leave everything else alone.
There is one table that I committed and later decided that I didn't want source controlled, so I unlinked it using SQL Source Control. Now when I sync with Data Compare, it wants to delete all the records from that table. Using the /exclude:additional option removes the table from the comparison, but it also removes deleted records from source controlled static tables that I do want included in the comparison.
Is there an option that I can use to say "do all inserts, updates, and deletes against the tables that exist in the source control folder, and ignore everything else?" Thanks.
I'm trying to use SQL Data Compare to sync my database with the changes in source control as part of a continuous integration system. I'm comparing against a script folder checked out from Subversion. I only want to sync the static tables that are in source control and leave everything else alone.
There is one table that I committed and later decided that I didn't want source controlled, so I unlinked it using SQL Source Control. Now when I sync with Data Compare, it wants to delete all the records from that table. Using the /exclude:additional option removes the table from the comparison, but it also removes deleted records from source controlled static tables that I do want included in the comparison.
Is there an option that I can use to say "do all inserts, updates, and deletes against the tables that exist in the source control folder, and ignore everything else?" Thanks.
Comments
So is this a problem with the way that SQL Source Control unlinks tables? Is there a way that I can file a bug report about that?
Redgate Software