Exclude Database Name from Compare

JohnH

Afternoon All

I was wondering if there were a way for SQL Compare to ignore database names in views. I have 2 databases to compare, one is my development db the other production. Both contain views that take data from another database, which have different names in dev and production.

As a result SQL Compare shows up a lot of views as different, when in fact they are really the same, just looking at different databases.

Dev example

SELECT MemberValue, MemberDescription
FROM PWA_Dev.dbo.[MSPLT_UserView]
WHERE (MemberDescription <> N'inactive') AND (MemberValue IS NOT NULL)

Production Example

SELECT MemberValue, MemberDescription
FROM PWA.dbo.[MSPLT_UserView]
WHERE (MemberDescription <> N'inactive') AND (MemberValue IS NOT NULL)

I'd like SQL Compare to ignore these differences if possible. If you have any thoughts please let me know.

Many thanks
John

Mike U

I'm afraid that SQL Compare is not currently capable of doing this. Please add your vote to this UserVoice request to help us prioritize this feature request against other potential enhancements.