Comments
Sort by recent activity
That is exactly what I see - but I use this all of the time - seems like an easy fix. / comments
That is exactly what I see - but I use this all of the time - seems like an easy fix.
Excellent - RG Rocks! / comments
Excellent - RG Rocks!
Jessica, Oddly enough - debugging the SP which wrote the data - we were using VARCHAR for the description? Not sure why your product would prefix the N for SQL 2008 and not prefix the N for the SQL 2017 version - but the second I made the change on my end it compared correctly. Maybe SQL is storing it as SQLVARIANT? Anyway - resolved although odd from your products point of view, Doug / comments
Jessica,Oddly enough - debugging the SP which wrote the data - we were using VARCHAR for the description? Not sure why your product would prefix the N for SQL 2008 and not prefix the N for the SQL ...
Yes. Your product consistently flags the columns as different, even though the same script has been applied to both databases. We are comparing a SQL 2008R2 instance vs a SQL 2017 instance. The 2008 version is always prefixed with N, the 2017 version is not. Kinda doesn't make sense - since the meta data itself is NVARCHAR for both. The odder issue is that it is only for the table meta data, not the column meta data. I can give you examples and screen shots - it happens 100% of the time. Doug / comments
Yes. Your product consistently flags the columns as different, even though the same script has been applied to both databases.We are comparing a SQL 2008R2 instance vs a SQL 2017 instance. The 2008...
Yes - thanks so much!
Ozzie / comments
Yes - thanks so much!
Ozzie
That fix worked perfectly!
Thanks again,
Ozzie / comments
That fix worked perfectly!
Thanks again,
Ozzie
james.billing had replied with the answer on 9/15/15 to me way back when.
We can now get the checkbox ‘Commit All Dependencies’ to default to unchecked – here is how.
To do this, you'll need to edit your UI Options file (RedGate_SQLSourceControl_CommonUI_UIOptions.xml) which you'll find here ( make sure you can view hidden directories on your machine ).
C:Users<your name>AppDataLocalRed GateSQL Source Control 5
Edit the file with say NotePad++, and at the very end add the line below in red
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<UIOptions version="1" type="UIOptions">
<PreferredSrcCSystem>1</PreferredSrcCSystem>
<PreferredDevelopmentModel>1</PreferredDevelopmentModel>
<AssemblyVersion>5.4.2.4269</AssemblyVersion>
<PreviouslyLinked>True</PreviouslyLinked>
<ConfigureFilteringFormX>258</ConfigureFilteringFormX>
<ConfigureFilteringFormY>19</ConfigureFilteringFormY> <IncludeDependenciesCheckbox>False</IncludeDependenciesCheckbox>
</UIOptions>
Note that a restart of SSMS is required for this change to take effect. / comments
james.billing had replied with the answer on 9/15/15 to me way back when.
We can now get the checkbox ‘Commit All Dependencies’ to default to unchecked – here is how.
To do this, you'll need ...
Wow - 1 day turnaround - not too shabby!
Ozzie / comments
Wow - 1 day turnaround - not too shabby!
Ozzie
TY - totally did the trick - somehow that had gotten reset and I couldn't find it.
Doug / comments
TY - totally did the trick - somehow that had gotten reset and I couldn't find it.
Doug
It is fixed in version 6.5.0.271 - fantastic job guys!
Ozzie / comments
It is fixed in version 6.5.0.271 - fantastic job guys!
Ozzie