> I'm talking about comparing the data within the tables. > Start out with identical data, do a bunch of data entry > to both systems, compare the data. I'm envisioning some > code where you input the data sources, the table names, > the matching field names, do a bunch of queries and or > loops and compare the data and spit out exceptions.
Ideally, you might do that from within a single query for each pair of tables. If they're on the same physical database server, this should be pretty easy. If they're not, you might be able to use the CF 5 query-of-query functionality. In either case, I think the approach I'd use would be to do an inequality join of some sort, although that's a pretty hazy answer. Something like this comes up when you want to find duplicate records within a single table; you use a self-join that might look something like this: SELECT ... FROM mytable t1, mytable t2 WHERE t1.pk <> t2.pk AND t1.natural_pk = t2.natural_pk In this case, though, the problem is a bit more complex, I think. You might do an inner join between the two tables, return the respective primary keys from the inner join, then select all the records with other primary key values. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
