SSDT comparison Does the comparison continue to find differences for users?

Question

The title says everything except the details. When I use the schema comparison tool in VS2015 for my SSDT project and my server database. Comparison results are always returned with users as different. I am checking the differences he is talking about, but there is no difference between the environments.

I even got to updating my project from the comparison results to correct these “differences”. Then I made another comparison, and the same users returned again with the differences ... WHAT! haha

Does anyone know what might cause this synchronization issue, or am I doing something wrong? Users were manually added to the database on the server, and not through the deployment of SSDT, maybe this is the reason?

EDIT:

Answer 1

Although I find this a bit of a workaround (I have not found a real solution to get rid of Users from comparisons, even if they are indentical), this is the best I have found. Just exclude users from comparison.

You can access this menu by clicking the gear icon in the schematic comparison window and expanding the object with the application area and unchecking the Users box (or whatever you want to exclude).

Answer 2

Please click the arrow to the left of the user differences found. You will see the properties folder and the missing login, which is the real difference. If you go to the page "Schema comparison options" → "Object types" (tab) → "Not for applications" → "Logins" to add the object type "Input" for comparison, then your problem will be solved.

Entry Objects

Answer 3

In Visual Studio 2017 at least (and this looks like an option in 2015), try going to the schema comparison options and under the "General" tab, disable the "Ignore login IDs" option.

I had the same problem with the user (where there was no login for the user), and disabling this option resolved the problem for me. I still took the correct user changes, but for existing users who have not changed, the comparison no longer shows a dummy element.