How to skip database name comparing in a view?

Forum for users of SQL Compare schema synchronization utility

How to skip database name comparing in a view?

Postby lucazav » Mon Jul 07, 2014 1:00 pm

Hi all,

I'm using SQL Compare
I'm wondering if there's a way to compare, for example, these two viewsfrom two databases:

Code: Select all
FROM MyDatabaseA.MyTable

FROM MyDatabaseB.MyTable

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

Thank you.
Posts: 8
Joined: Thu Aug 26, 2010 10:18 am
Location: Italy

Postby Brian Donahue » Wed Jul 09, 2014 4:51 pm

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.

Hope this helps.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests