visual studio - Include but not Delete SQL Schema Compare -

i attempting use sql schema compare in visual studio 2013/15 , running problem discluding tables delete removes them being processed @ all.

the issue tables trying delete customer made tables, when sync our version against databases asks delete them. not want delete them, of tables have constraints on ours when attempts ccdr fails due table constraints. there way add table (re-created? rest of them?), without writing scripts each client sql schema compare few tables?

red-gate's sql compare somehow, it's hidden not quite sure how it's achieved. discluding doesn't delete, not error on script either.

update:

the option "drop constraints not in source" not appear work correctly. drop some, there others not drop constraints. in red-gate's tool, when compared found how sql it, , product doesn't table needs updated @ all, while visual studio's does. seem work identical, tables fail ones shouldn't update @ (read below)

update 2:

another problem i've found "ignore column collation" doesn't work correctly, tables shouldn't getting dropped being told need updated though it's order of column changes, not actual column or data changes, makes feel more of bug report anything.

my suggestion these types of advance data calculations not use visual studio. put logic on sql engine , write code in sql. due multi user locking issues of sql engine these types of processes prone fail when wrong combinations of user actions happen @ same time. visual studio tool can not interface data locking issues due records changing sql engine can. if work safe run if in single user mode.

it nice use tool, easier writing sql there huge reliability , consistency risks going down path.