ReadyRoll and "Collation"

TiltonJH

Hello,

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

dnlnln

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.

TiltonJH

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?

dnlnln

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.