Commit All Dependencies - I'd like the checkbox unchecked

• 
  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.

  Ozzie February 08, 2017 11:53

  - 0 +
• 
  This doesn't seem to work in version 6.
  

  turbopocky April 18, 2018 15:51

  - 0 +
• 
  Hi,
  
  In version 5 and 6 it will not work for migration scripts, it works for regular schema changes.
  
  Thank you,

  Sergio R April 19, 2018 12:30

  - 0 +

Add comment

Please sign in to leave a comment.