Compare tables with different names?
jamieuka
Posts: 6
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.
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.
Comments
Yes, no problem at all, just create a mapping between SP and SP2.
http://www.red-gate.com/supportcenter/c ... ataSources