Comments
Sort by recent activity
Hi
Deleting the SQL Source Control v2 directory tree without first unlinking the database from SQL Source Control via the user interface would cause the behaviour you describe. Although, it is worth stating that SQL Source Control v3 will work fine with databases with a working base under the v2 folder.
However, if you'd prefer the working base to be under the "SQL Source Control 3" please unlink the database first, delete the unwanted working base folder and link the database again.
Best regards,
Chris / comments
Hi
Deleting the SQL Source Control v2 directory tree without first unlinking the database from SQL Source Control via the user interface would cause the behaviour you describe. Although, it is wort...
Hi
Can you please confirm what you mean by 'associated objects'?
In SQL Source Control version 3 we added Migration Scripts, which must be committed with associated objects. We also enforce changes to be committed together it they are Data and Schema changes related to the same object.
Would you be able to post some brief steps we can take to reproduce the issue?
Many thanks,
Chris / comments
Hi
Can you please confirm what you mean by 'associated objects'?
In SQL Source Control version 3 we added Migration Scripts, which must be committed with associated objects. We also enforce changes...
Hi
In the latest version of SQL Source Control there is no option to configure the comparisons performed by the product (unlike SQL Compare - as you mentioned).
However, we are currently working on adding a comparison options configuration file to SQL Source Control that will allow you to detect synonym changes (and change many of the other options available in SQL Compare).
We are hoping to release this in the next few weeks via our 'Check For Updates' mechanism. I will add a post to this thread when that build is available.
Best regards,
Chris / comments
Hi
In the latest version of SQL Source Control there is no option to configure the comparisons performed by the product (unlike SQL Compare - as you mentioned).
However, we are currently working on...
Hi
SQL Source Control v3.0.5.7 includes a mechanism to allow comparison options (such as detecting synonyms) to be configured.
To get this version, please run Check For Updates from the Help menu in SQL Source Control. This is a free upgrade for existing licensed v3 users and for users with a Support & Upgrades contract.
Comparison options can now be set via a configuration file in your database repository's Working Base folder. The following Knowledge Base support article describes how to configure this option: KB201202000521 - Setting SQL Compare options within SQL Source Control
Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often, but we believe this configuration file procedure should help users in the interim.
If you'd like to see an options dialog exposing these settings in SQL Source Control, please vote on the associated Idea on our UserVoice site. It'd be great if you could also leave a comment indicating which specific options you'd like to see in the dialog.
Best regards,
Chris / comments
Hi
SQL Source Control v3.0.5.7 includes a mechanism to allow comparison options (such as detecting synonyms) to be configured.
To get this version, please run Check For Updates from the Help menu i...
Hi
SQL Source Control v3.0.5.7 includes a mechanism to allow 'Ignore FillFactor' to be configured.
To get this version, please run Check For Updates from the Help menu in SQL Source Control. This is a free upgrade for existing licensed v3 users and for users with a Support & Upgrades contract.
Comparison options can now be set via a configuration file in your database repository's Working Base folder. The following Knowledge Base support article describes how to configure this option: KB201202000521 - Setting SQL Compare options within SQL Source Control
Our plan in the future is to provide an options dialog to allow users to configure the comparison options that are changed most often (which is likely to include fillfactor), but we believe this configuration file procedure should help users in the interim.
If you'd like to see an options dialog exposing these settings in SQL Source Control, please vote on the associated Idea on our UserVoice site. It'd be great if you could also leave a comment indicating which specific options you'd like to see in the dialog.
Best regards,
Chris / comments
Hi
SQL Source Control v3.0.5.7 includes a mechanism to allow 'Ignore FillFactor' to be configured.
To get this version, please run Check For Updates from the Help menu in SQL Source Control. This i...
Hi
Just to explain why this behaviour has changed - we had a number of requests to stop ignoring FILLFACTOR and INDEXPADDING by default in the comparisons that SQL Source Control performs. Ignoring these changes is the default option for SQL Compare, but we thought it was a change that SQL Source Control users would generally want to see.
However, what we really want to do is allow the user to configure this setting (as they can in SQL Compare)....
Therefore, we are currently working on adding a comparison options configuration file to SQL Source Control that will allow the user to set FILLFACTOR to be ignored if they so wish.
We are hoping to release this in the next few weeks via our 'Check For Updates' mechanism. I will add a post to this thread when that build is available.
Best regards,
Chris / comments
Hi
Just to explain why this behaviour has changed - we had a number of requests to stop ignoring FILLFACTOR and INDEXPADDING by default in the comparisons that SQL Source Control performs. Ignoring...
Hi
We have now got to the bottom of this problem and believe it is a bug in SQL Source Control related to case-sensitivity. The fix should be in the next build we release via Check For Updates - we expect this to be out next week.
Best regards,
Chris / comments
Hi
We have now got to the bottom of this problem and believe it is a bug in SQL Source Control related to case-sensitivity. The fix should be in the next build we release via Check For Updates - w...
Hi
Thanks for that. Unfortunately, that does not point to a Compatibility Level problem and we can't recreate your issue yet.
Can you please send us the entire 'database' and 'latest source control' scripts for your example below?
Also, if you have SQL Compare v10, would you be able to do a comparison between your source control repository and your database to see if the parentheses difference shows up there too?
Thanks
Chris / comments
Hi
Thanks for that. Unfortunately, that does not point to a Compatibility Level problem and we can't recreate your issue yet.
Can you please send us the entire 'database' and 'latest source contro...
Hi
We think the issue may be that SQL Source Control has not correctly picked-up the compatibility level of your datbase.
Could you please let us know a couple of pieces of information to help us confirm this?
1. What version of SQL Server is the database running on (2005, 2008, 2008 R2)?
2. What is the Combatibility Level for the db you are source controlling? To find out, go to the Database Properties dialog for the db and select the Options section.
3. What is the database version listed in the RedGateDatabaseInfo.xml file stored in your repository? This file is stored in the "Schema" folder SQL Source Control has created in your version control system.
Thanks,
Chris / comments
Hi
We think the issue may be that SQL Source Control has not correctly picked-up the compatibility level of your datbase.
Could you please let us know a couple of pieces of information to help us c...
Hi
An Early Access Release of SQL Source Control v3.1 is now available that includes a solution to the 'Changed by = Unknown' problem.
For more details, and a download link, please see: http://www.red-gate.com/MessageBoard/vi ... hp?t=15345
Thanks,
Chris / comments
Hi
An Early Access Release of SQL Source Control v3.1 is now available that includes a solution to the 'Changed by = Unknown' problem.
For more details, and a download link, please see:http://www.r...