Is it possible to compare two databases with different names? I read that you can do this with mapping for Data Compare but the mapping in SQL Compare only seems to map users and not tables.
SQL Compare does not currently support object-level mapping, unfortunately.
(This is because it would require rewriting stored procedures, foreign keys etc that refer to the tables, and we're somewhat reluctant to start rewriting people's objects quite that extensively...)
Any advice?