Re: Need to Compare two databases

Posted in 1997

Michael Poremba — Thu, 23 Oct 1997 23:55:55 -0400 — source: Informix-list mailing list archive (1991-1998)

KPonn wrote in message <19971019155000.LAA15894@ladder02.news.aol.com>... > > We will stop the cycle in the middle and compare this test database with the > snap shot I took in the middle. We hope to see these two databases are exactly > the same. And we finish the cycle and compare final database from this test > with "after cycle" snap above. questionable !) > >Questions: 1. Is this the best way to do it ? If yes, how do I compare two > databases (I mean entire database !). > 2. If not, Is there any other alternative ? Keith: When you perform a dbexport of the two databases you will get bunch of *.unl text files containing the table contents. You should be able to run file comparisons on these files from different databases to see whether the data matches. Michael mporemba@moscom.com