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...