Re: Best Way to Compare Informix Databases
Have you look at systables and syscolumns tables?
Select only the columns you need and compare it with another database.
At 1/28/99 02:55 PM , Tim Owens wrote:
>What is the best way to compare two informix databases?
>
>My current approach is to run dbschema on both databases, then diff the
output.
>
>However, since diff only does a line-by-line file comparison, one difference
>between the databases causes a domino effect in the line-by-line comparison
>of the schema output.
>
>Does informix have a built-in tool that would provide a better way?
>
>Any help would be appreciated,
>
>Tim Owens
>
========================
Susik Lee
slee@gus.net
========================