SQL Source Control 3

Disabling TFS policy checking

TFS policy enforcement is only available in SQL Source Control version 3.3 and later.

If you don't want your commits to have to conform to TFS policies, you can stop SQL Source Control checking for TFS policies by editing a config file.

  1. Close SQL Server Management Studio.
  2. Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 3
  3. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

  4. Below the EngineOptions version line, add:

    <IgnoreTfsPolicies>True</IgnoreTfsPolicies>

    The file is case sensitive. Don't change the capitalization of the text.

    Ignoring any comments (indicated with <!->), the final file should look like this:

    <EngineOptions version="3" type="EngineOptions">
    	<IgnoreTfsPolicies>True</IgnoreTfsPolicies>
    </EngineOptions>

    The example above doesn't include any extra lines you may have included. For example, you may have included additional lines to set up change logging.

  5. Save and close the file.

SQL Source Control will now ignore any TFS policies when committing your changes to source control.

To turn policy checking on again, set the <IgnoreTfsPolicies> value to False.

If you're having problems with TFS policy checking, updating to the most recent version of SQL Source Control should fix them. You may still need to follow the instructions on this troubleshooting page. If you're still having problems, contact Redgate support.



Didn't find what you were looking for?