Visual Studio 2010 - Schema Compare - Specify Database (Security) Schema
I am using Visual Studio 2010's database functionality to compare database schemas. I am comparing database#1 and database#2开发者_JS百科. 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.
Create two other databases, db1c and db2c, which only contain the objects with the schemas you want to compare.
精彩评论