I want to compare two big tables if they are identical. If I update/insert one table into the other the process takes about 11 hours.
What I am looking for is like a sum function which sum ups a key for each row and then I would like to compare the two sums. I guess I would need to take every of the 40 columns into that key to be sure they are exactly the same.
Any idea how to do this quick? Ah I forgot one big thing: these tables are on different systems stored in different DMS. The source is DB2 and the copy is MySQL.
I read about the Checksum function in MySQL. - I also read, that it somewhat restricted to MyISAM - I reade that two tables with the same checksum could still have no identical content. -> might not be what I am looking for. Other ideas are apprechiated.