Re: Informix Question
Hi,
I am not sure whether there is any generic utility available.
But I use my own scripts ( I have one in 4gl and other in Shell script).
I check for the difference of the tables and columns and sequence of
the columns, datatypes in 4GL script and in addition to these I check for
Indexes, PKs and FKs in Shell script.
If you need I can e-mail it to you.
IF THERE IS ANY GENERIC UTILITY AVAILABLE PLEASE LET ME KNOW.
Thanks & Regards,
Srinivas Reddy
On 9 Sep 1996, Ramana Nyapathi wrote:
}
}
} I am posting this on behalf of a friend. He does not have access to the
} newsgroups. Please email your responses to rgoyal@fivepaces.com
}
} --------------------------------------------------------------------------
}
} Informix experts,
}
} I am faced with a situation to be able to compare two database schema's to
} see if they are the same and if not what are the diffrences. I am working
} with informix (on-line) 7.1.
}
} Does anybody know of a utility existing which would do the stuff. I am sure
} someone was sometime faced with this situation.
}
}
}
} More details: On Why I need to compare:
} We apply sql scripts to upgrade our products database to latest level. We
} also release a schema with each release.
} The schema that is released(new installations) is always correct but the sql
} scripts that are released alongwith for the upgrade, are sometimes inadequate.
}
} To provide a check against inadequate sql scripts released for upgrade, I
} wannted to use the released sql's to upgrade a test DB and then compare it with the dbschema released.
}
} Please reply to
} rgoyal@fivepaces.com
} thanks in advance
} Rajiv Goyal
}