I am using Visual Studio 2010's database functionality to compare database schemas. I am comparing database#1 and database#2. I would like to compare only only objects within the same security schema within my databases (dbo, myschemaname, etc.) rather than comparing all objects within that database but I cannot figure out how to do so. Does anyone have any way of doing this?
There is no inbuilt way to filter the examined objects based on name, only by type. Gosh, that'd be a nice feature to have -- you should file a feature enhancement request with Microsoft. :-)
The only solution I can think of -- and I'm hesitant to even call it that -- would be to create separate logins on both servers that only have access to specific schemas.