Search code examples
sql-servervisual-studio-2010schema-compare

Can schema be ignored in object names in VS 2010 Schema Compare?


Is it possible to ignore the schema in object names when comparing databases using Visual Studio 2010 Schema Compare? For example, I'd like [dbo].[mysproc] and [mysproc] to be considered equivalent.


Solution

  • Are these references in stored procedures?

    I don't think that there's any way of achieving this. As far as I'm aware stored procedures are compared textually, rather than semantically.