>>> "Michael Nacos" <m.nacos@xxxxxxxxx> wrote: > what if you actually want to look at the data? I have been > thinking about row checksums, would you say this would be a reasonable way > of verifying two databases are equivalent? Our home-grown replication technique does synchronization checks during idle time. It works pretty well for us, and we do use md5sum techniques to minimize bandwidth. In summary, a process requests a middle tier on a "source" machine to send "sync" information; that middle tier reads some set of rows and sends the md5 sum of all data in the rows, along with information on what rows from which table were used to develop the number. The requesting process then asks similar middle tiers on all replication targets to return their md5sum for the same set of rows. If there are any differences, the source and all differing replication targets are queried for the actual values, which are compared using match-merge type logic on the primary key sequence. Something similar might work for you. -Kevin
