Options

How to skip database name comparing in a view?

lucazavlucazav Posts: 12
edited July 9, 2014 11:51AM in SQL Compare Previous Versions
Hi all,

I'm using SQL Compare 10.7.0.18.
I'm wondering if there's a way to compare, for example, these two viewsfrom two databases:
SELECT *
FROM MyDatabaseA.MyTable

SELECT *
FROM MyDatabaseB.MyTable

and make SQL Compare don't show them as different.

Thank you.
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    SQL Compare has a few options to ignore certain object properties, but it does not do any refactoring where programmability objects like views, stored procedures, and UDFs are concerned. You can map the owning schema to a different owner and that's about it. There definitely isn't support for manipulation of three-part identifiers (database.schema.object).

    If it's important, you could consider requesting this feature on UserVoice. https://redgate.uservoice.com/forums/141379-sql-compare

    Hope this helps.
    · Share on Twitter
Sign In or Register to comment.