SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Visual Studio 2019 SQL Schema Compare and Collation
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
doug.moloney@uchealth.com
6
Reputation points
I am comparing two database schemas in Visual Studio 2019, most recent version.
I would like to ignore the Column Collation, however, the option doesn't seem to work when its checked.
I have it checked.
It still is showing as a difference. Why is it showing a difference, I told it to ignore.
SQL Server | Other
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff2021-09-24T01:29:25.03+00:00 Hi molonede,
According to my test, I encountered the same issue as you.
I’m not sure if it is an issue or by design.
If you have any wish to make feedback requests, you can submit it to the visual studio feedback at this link: https://developercommunity.visualstudio.com/search?space=8Best Regards,
Amelia
Sign in to comment
Sign in to answer