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
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.
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