Re: Comparing databases

Posted in 1999

Clem Akins — Tue, 19 Jan 1999 13:30:15 -0800 — source: Informix-list mailing list archive (1991-1998)

At 03:43 PM 19-01-99 -0500, Russ_Evans@doh.state.fl.us wrote: >Have recently had need to export then re-import a large number of databases. >Easy 'nuff, but I'm looking for a script that will compare two databases for >consistency; the old database which was renamed after exporting, and the >reimported version. (requires some extra space, but you can never be too >safe) Couldn't find such a script on the IIUG page. Anyone written one of >these already? Hate to re-invent the wheel, especially when all of my wheels >turn out square... Doesn't Jack Parker's DBDIFF2 do that? Available in the DBA section of the IIUG software library, it generates SQL to make one database like another. If no SQL, the two databases are the same. _______________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: Lovin' the cold but sunny San Francisco bay area...