3

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?

wonea
  • 4,783
  • 17
  • 86
  • 139
Jason Irwin
  • 1,985
  • 2
  • 29
  • 42

2 Answers2

2

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.

Warren Rumak
  • 3,824
  • 22
  • 30
  • Thanks for the response. I have indeed filed an enhancement request on Connect (https://connect.microsoft.com/VisualStudio/feedback/details/587557/schema-data-comparison-filter-by-security-schema) – Jason Irwin Aug 24 '10 at 14:48
-3

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

Beth
  • 9,531
  • 1
  • 24
  • 43