Commit All Dependencies - I'd like the checkbox unchecked

OzzieOzzie Posts: 46 Bronze 5
edited February 8, 2017 11:53AM in SQL Source Control
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? :D

TIA,
Doug
Tagged:

Comments

  • OzzieOzzie Posts: 46 Bronze 5
    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.
  • turbopockyturbopocky Posts: 5 New member
    This doesn't seem to work in version 6.
  • Hi,

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

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.