0

In the Visual Studio 2015 SSDT "Advanced Publish Settings" Window, Tab General, "Advanced Deployment Options" there are several checkboxes in the column "ENABLED" we can check or uncheck.

Most of the descriptions in there (that are also documented here) say something like this:

"Specifies whether differences in the database collation should be ignored or updated when you publish to a database."

enter image description here

Now, it's completely undefined what exact consequences checking this box has: ignored OR updated? Does it ENABLE IGNORE or ENABLE UPDATE?

Does anyone know?

It is so annoying that people create software and never ever notice that their wording is misleading and unclear...

4

The checkbox applies to each option "positively" so that e.g. ticking "script database collation" will generate the appropriate statements to alter collation settings. If not ticked, the deployment will ignore those differences by not scripting the changes.

  • HI, do you by chance have any reference to look up? I could not find it. – Magier Feb 2 '16 at 12:38
  • 2
    @Magier The "enabled" refers to the option, not to parts of the option's definition. You either enable the scripting of the DB collation, or you do not enable the scripting of the DB collation. It seems reasonable to interpret this as meaning "scripting DB collation = updating" (you aren't ignoring something when you issue statements to do it) and "not scripting the DB collation = ignoring" (you can't alter something if no statements are scripted out to do it). I'm not being snide/rude, just pointing out why there is likely no reference for this. Also test both ways & check the _Create script. – Solomon Rutzky Feb 2 '16 at 18:14
  • sqlpackage has some docs on these items, including ScriptDatabaseCollation – Stafford Williams Nov 30 '17 at 0:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.