Allow objects to be committed without their dependencies
I am working on a project that is an enhancement to an existing database that is controlled by an external party. I am referencing objects that I have no control over via foreign keys, presently I cannot commit the foreign keys to source control unless I also commit the dependent objects. I do not want to commit these as I do not control them.
Would it be possible to have some mechanism that permits me to commit my changes without the dependencies, something like an override checkbox for the default behavior that will also place messages in the notification box when committing much like the ones where objects are created on different file groups.
The latest frequent-update version of SQL Source Control (220.127.116.11) allows you to default the checkbox behaviour to off. To do this, you’ll need to edit your UI Options file (RedGate_SQLSourceControl_CommonUI_UIOptions.xml) which you’ll find in localappdata\Red Gate\SQL Source Control 4 and add a tag called IncludeDependenciesCheckbox, like this:
<IncludeDependenciesCheckbox>False</IncludeDependenciesCheckbox>If the value is false, then the checkbox will be un-set by default.
We need this option too.