Source Controlling Data removes DROP CONSTRAINT
To save the trouble of everyone in my department manually clicking on which tables to source control data, I've been saving insert scripts toTFS's data folder, so when users click on "get latest", the data is ready to source control along with obejcts. Because the database has many tables, I've been having to drop constraints and add them with nocheck to avoid any foreign key errors. However, when I click on get latest in source control, I see any alter table statements are removed - it's just the insert.
I know those are changes to objects, not data, but I'm using data compare to generate the insert scripts which includes altering the constraints. I figured Source Controlling Data uses data compare but I guess it's not the case? Is the problem that I'm having one with TFS or Redgate?