Compare tables with different names?

jamieuka

For example, I want to compare a base table named `SP` with a second base table named `SP2` (in the same database but can be copied to another database if required).

I found a support article entitled Selecting Tables With Unrelated Names but it seems to still compare tables using exact names, merely applies a 'fuzzy filter' to determine which tables to include.

Brian Donahue

Hello,

Yes, no problem at all, just create a mapping between SP and SP2.
http://www.red-gate.com/supportcenter/c ... ataSources

jamieuka

Thanks, I see now, very easy