Syntactic Confectionery Delight | |
PerlMonks |
Re^2: Comparing information in 2 databasesby mpeppler (Vicar) |
on Jan 15, 2005 at 17:48 UTC ( [id://422530]=note: print w/replies, xml ) | Need Help?? |
You can, using various functionality, but this may require administrator privileges, which the user may not have. A perl script that pulls data and does an MD5 hash or something similar may be a reasonable way to do this (assuming the size of the tables isn't overly large). Another way (which only works if both servers are quiescent) is to bulk-copy all of the data to OS files and checksum the resulting files (be careful of row ordering, however). This won't tell you where the differences are, but it will tell you if the data is identical. Michael
In Section
Seekers of Perl Wisdom
|
|