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.
- Close SQL Server Management Studio.
- Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 3
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
EngineOptions versionline, add:
Ignoring any comments (indicated with
<!->), the final file should look like this:
- 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