Search This Blog

February 10, 2014

Turn off unimportant object types when doing database comparison in Visual Studio 2013

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:

SQL Server : Database Schema Comparison Tool for Different Environments

No comments: