Competition: What’s your favorite Redgate tool? Enter now.

ReadyRoll and "Collation"

Hello,

does ReadyRoll compare the "Collation" settings of an column?
As far as I can tell it doesn't.
Is this correct?
Tagged:

Answers

  • You are correct that ReadyRoll ignores column collation settings, however this behaviour can be overridden. To do so, edit your project (.sqlproj) file and add the following below the <Project> node:
    <PropertyGroup>
      <SyncOptionIgnoreCollations>False</SyncOptionIgnoreCollations>
    </PropertyGroup>
    

    After making this change, build your solution. The next time you use the ReadyRoll tool-window, the collation settings should be included in the comparison.

    For more information, see Configuring comparison & script generation options.
    Daniel Nolan
    Product Manager
    Redgate Software
  • TiltonJHTiltonJH Posts: 2 New member
    Took me awhile to revisit my issue...

    Thx, this might do the trick. However I forgot to mention that I use the free core version that ships with VS 2017.

    This feature is not supported within core version correct?
  • TiltonJH said:
    Took me awhile to revisit my issue...

    Thx, this might do the trick. However I forgot to mention that I use the free core version that ships with VS 2017.

    This feature is not supported within core version correct?
    Indeed, unfortunately this option is not licensed to users of Core edition at present.
    Daniel Nolan
    Product Manager
    Redgate Software
Sign In or Register to comment.