Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
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:
- Code: Select all
and make SQL Compare don't show them as different.
- Posts: 8
- Joined: Thu Aug 26, 2010 10:18 am
- Location: Italy
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.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests