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

Africah

Let's start with the obvious: are you comparing databases with identical schemas? Remember, we only have the information you give us. Please read How to Ask. – Widespread

Seems like a valid question. I have the same problem. – Alberta

Check the error list from View -> Error List, mine was timeout issue, I tried by re-selecting source and target and making sure to select "Remember Password", this worked for me. – Bellybutton

Same error, need to check the Error tab, else won't know what happen. VS should have made the error more obvious. Set "Remember Password" fix the issue. – Hom

Try closing visual studio and restarting your PC it works then. – Evite

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.

Intend

Answer 2

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

Cradle

Answer 3

I was facing the same issue. As per suggestion of Manthan Devani, I enabled the error list from View -> Error List.
This showed that the user did not have enough priviliges. The following grant statement solved the issue and I was able to see the comparison result:

USE yourDbName
GO
GRANT VIEW Definition TO yourUser

Mcmurry

Answer 4

I encountered the same issue, but I was able to resolve it by checking and adjusting the Target Platform in the properties of the DB project.

Skep