visual studio 2019 schema compare no differences detected

Question

I am using New Schema Comparison to compare 2 Databases but this tools return " compare no differences detected "
I am using VS 2019

Answer 1

Have a look at the Error List in Visual Studio.

In my case it contained errors, but it's not obvious that an error has occurred from the SQL Schema Compare UI.

Answer 2

I just faced the same problem. In my case, it was because the database user did not have enough privileges.