Visual Studio 2010 - Schema Compare - specify database schema (security)

Question

I am using Visual Studio 2010 database functionality to compare database schemas. I am comparing database # 1 and database # 2. I would like to compare only objects within the same security scheme in my databases (dbo, myschemaname, etc.), and not compare all objects inside this database, but I don’t I can understand how to do it. Does anyone have a way to do this?

Answer 1

There is no built-in way to filter the considered objects based on the name, only by type. Gosh, that would be a nice feature - you should ask for a feature enhancement at Microsoft. :-)

The only solution I can think of, and I hesitate to even name it, is to create separate logins on both servers that have access only to certain schemes.

Answer 2

Create two other databases, db1c and db2c, which contain only the objects with the schemas you want to compare.