Add an 'Ignore owner/schema' option to SQL Compare
I'd really like this ignore option, so that [UserA].[Table] on the left hand side would match with [dbo].[Table] on the right hand side. There obviously needs to be a warning that this won't work unless table names are unique between owners/schemas (which, in my experience, they usually are).
-
Have you tried the schema mapping feature? https://documentation.red-gate.com/sc/setting-up-the-comparison/mapping-owners
-
Kenny commented
I'm dealing with a bunch of databases where the all the objects type and names that are same or should be the same, but all with different schemas prefix. I need to do compare based on different schema names. Please add this feature!