| Author |
Message |
David Atkinson
Joined: 05 Dec 2005
Posts: 1082
|
|
| Back to top |
|
 |
kevine323
Joined: 27 Jul 2006
Posts: 39
|
 Posted: Thu Jul 12, 2012 8:45 pm Post subject: Works Great! |
 |
|
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
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/ |
|
| Back to top |
|
|
decode
Joined: 26 Jul 2012
Posts: 1
|
| Posted: Thu Jul 26, 2012 6:00 am Post subject: Case sensitive object definitions |
|
|
| 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? |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Thu Jul 26, 2012 4:07 pm Post subject: |
|
|
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: |
<DefaultCollation>Latin1_General_CS_AS</DefaultCollation>
|
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Tue Jul 31, 2012 11:41 am Post subject: |
|
|
Just following up: did changing the RedGateDatabaseInfo.xml file get the database to work in a case-sensitive way?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
tyson
Joined: 19 Oct 2012
Posts: 1
|
|
| Back to top |
|
|
bigminer
Joined: 05 Nov 2012
Posts: 2
|
| Posted: Mon Nov 05, 2012 10:52 pm Post subject: ComparisonOption not automatically used |
|
|
| Quote: |
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. |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6369
Location: Red Gate Software
|
| Posted: Tue Nov 06, 2012 11:13 am Post subject: |
|
|
Can you please post this suggestion to UserVoice?
http://redgate.uservoice.com/forums/39019-sql-source-control
Thank you.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
pahlquist
Joined: 28 Feb 2013
Posts: 2
|
| Posted: Thu Feb 28, 2013 6:52 pm Post subject: |
|
|
In the version of SSC that I am using (3.0.13.4214...on 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 folder...it does not seem to take affect even after restarting SSMS.
Thoughts? |
|
| Back to top |
|
|
|
