How to specify comparison options in SQL Source Control

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

How to specify comparison options in SQL Source Control

Postby David Atkinson » Tue Jun 19, 2012 10:48 am

The comparison and synchronization options available in SQL Compare can also be specified in SQL Source Control using the instructions posted here: ... 1202000521

Please let us know which options are most useful to you so we know which ones to fully implement in an Options dialog.

David Atkinson
Red Gate
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Works Great!

Postby kevine323 » Thu Jul 12, 2012 7:45 pm

This works great on large databases with many encrypted stored procedures. Without setting the "DecryptPost2kEncryptedObjects" to false, it would take 30+ minutes for Source Control to look for our changes. Thanks for sharing this!
Kevin Eckart
Database Administrator
USA Truck, Inc
Posts: 40
Joined: Thu Jul 27, 2006 9:23 pm

Case sensitive object definitions

Postby decode » Thu Jul 26, 2012 5:00 am

I've tried manually adding "CaseSensitiveObjectDefinition" (as "True") in the ComparisonOptions.xml file but it doesn't seem to have any effect in SQL Source Control. Is anybody else having the same issue or am I missing something?
Posts: 1
Joined: Thu Jul 26, 2012 4:55 am

Postby Brian Donahue » Thu Jul 26, 2012 3:07 pm

I've had a look at the source code, and if I understand it correctly, the case-sensitivity is set by setting the appropriate case-sensitive collation in RedGateDatabaseInfo.xml file. Can you please try that and let me know if that works?

For instance:
Code: Select all
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby Brian Donahue » Tue Jul 31, 2012 10:41 am

Just following up: did changing the RedGateDatabaseInfo.xml file get the database to work in a case-sensitive way?
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby tyson » Fri Oct 19, 2012 5:19 am

SQL Source Control added support for TFS 2012 in version 3.1. The implementation leaves something to be desired, so 3.1 had been pulled from public release.
Posts: 1
Joined: Fri Oct 19, 2012 5:17 am

ComparisonOption not automatically used

Postby bigminer » Mon Nov 05, 2012 9:52 pm

You are recommended to commit this file into your source control system (SQL Source Control will not do this for you, so use the client relevant to the source control software you are using, i.e. Tortoise if you are working with SVN) so that other developers can retrieve the file into their own Working Base, ensuring that all users are working with the same options.

If you need to unlink and re-link your database, you will also need to Get the file from your source control repository, as re-linking creates a new Working Base folder.

Checking the ComparisonOption.xml file in source control is easy enough. However, if i unlink and re-link I have to "know" to go to the working base folder and update from source. I then have to close SSMS and reload. This is not going to go over well with my development teams. I hope there are plans to have it automatically retrieve the ComparisonOptions.xml from source if it already exists and use it before comparing source and database.
Posts: 2
Joined: Mon Nov 05, 2012 8:59 pm

Postby Brian Donahue » Tue Nov 06, 2012 10:13 am

Can you please post this suggestion to UserVoice? ... ce-control

Thank you.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby pahlquist » Thu Feb 28, 2013 5:52 pm

In the version of SSC that I am using ( Win7/SQL 2008 R2 SSMS)...right clicking on the linked-to path does not bring up the context window shown in the article referenced in this forum. The context menu that comes up only contains "Copy". The article says any version after 3.0.5 should support this. In the past this has worked fine for me. If I manually copy an old ComparisonOptions.xml to my does not seem to take affect even after restarting SSMS.

Posts: 2
Joined: Thu Feb 28, 2013 5:23 pm

Re: How to specify comparison options in SQL Source Control

Postby jengenl » Tue Mar 31, 2015 8:31 pm

Elegantly works on large databases :P
The best thing I found some kind of on the internet clash of kings cheats
Posts: 3
Joined: Tue Mar 31, 2015 8:29 pm

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests