How to apply changes to Informix database(s)?

We have a set of Informix-4GL applications which use a number of databases in a partition (Informix-ONLINE), for which we need to make a new release. As part of the next version we have: 1. Introduced some new databases. 2. Added some tables to existing databases. 3. Added some fields to existing tables. 4. Removed some fields from existing tables. This is all in addition to the code changes which operate on the databases. I need to come up with a procedure or set of tools, which can help automate the conversion/upgrade of the database(s) from one version (old) to the next (new). Are there any tools, or recommendations, from anyone that may have done this before? I am in the initial research stages, so I am looking at different alternatives. One suggestion has been to do a dbschema of the old database(s) and new database(s), and use the differences to build a set of isql commands to apply the changes to the old database. -- Donald E. Amby amby@mixcom.com 414-797-6713 (voice) 414-797-6533 (FAX) Harnischfeger Engineers, Inc., P.O.Box 1512, Milwaukee, WI 53201-1512