When using Visual Studio 2013 to do database comparison between 2 environments (DEV & TEST), I only care about the following things :
1. Table names are identical.
2. Table Column names are identical.
3. Stored Procedures are identical.
However, when using Visual Studio 2013, I can still see something unimportant like users, index and other unrelated object types. That’s because Visual Studio 2013 turns on these Object Types by default.
Just select Stored Procedures & Tables only and do database comparison again. That’s the information I really want to see.
Please see also: