These pages cover SQL Source Control 3. Help for older versions is also available.

SQL Source Control includes an optional beta version of the improved migration script feature. We'd love to hear what you think.

Skip to end of metadata
Go to start of metadata
Icon

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.

Editing the 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:

    Icon

    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:

    Icon

    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.

Icon
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 Red Gate support.


  • No labels