What are best possible ways to compare structure and content of two huge databases dump files almost 10GB file sizes.
Options already considered:
1). I can take the meta data and compare the tables row by row after loading the databases, but that will take over a month to get it done. Not acceptable.
2). Normal file diff doesn’t work.
3). I may have to do this operation multiple times in a typical cycle. Checksum works good for small DB’s but not for huge ones.
Appreciate your suggestions.