Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^2: Comparing information in 2 databases

by mpeppler (Vicar)
on Jan 15, 2005 at 17:48 UTC ( [id://422530]=note: print w/replies, xml ) Need Help??


in reply to Re: Comparing information in 2 databases
in thread Comparing information in 2 databases

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

  • Comment on Re^2: Comparing information in 2 databases

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://422530]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2024-04-25 19:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found