Commit All Dependencies - I'd like the checkbox unchecked

Ozzie

RG,

When we are checking in code - we need the 'Commit All Dependencies' checkbox to come up unchecked - is there a setting I can modify to make this happen now that we have migrated to 5.0?

TIA,
Doug

Ozzie

james.billing had replied with the answer on 9/15/15 to me way back when.

We can now get the checkbox ‘Commit All Dependencies’ to default to unchecked – here is how.

To do this, you'll need to edit your UI Options file (RedGate_SQLSourceControl_CommonUI_UIOptions.xml) which you'll find here ( make sure you can view hidden directories on your machine ).

C:Users<your name>AppDataLocalRed GateSQL Source Control 5

Edit the file with say NotePad++, and at the very end add the line below in red

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<UIOptions version="1" type="UIOptions">
<PreferredSrcCSystem>1</PreferredSrcCSystem>
<PreferredDevelopmentModel>1</PreferredDevelopmentModel>
<AssemblyVersion>5.4.2.4269</AssemblyVersion>
<PreviouslyLinked>True</PreviouslyLinked>
<ConfigureFilteringFormX>258</ConfigureFilteringFormX>
<ConfigureFilteringFormY>19</ConfigureFilteringFormY>
<IncludeDependenciesCheckbox>False</IncludeDependenciesCheckbox>
</UIOptions>

Note that a restart of SSMS is required for this change to take effect.

turbopocky

This doesn't seem to work in version 6.

Sergio R

Hi,

In version 5 and 6 it will not work for migration scripts, it works for regular schema changes.

Thank you,