Hi,
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.
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.
Comment