Tool to upgrade a database schema

Posted in 2004

Wes Gray — Wed, 08 Dec 2004 19:27:58 GMT — source: Usenet: comp.databases.informix

We have a large schema which we give to our users. Regularly we also modify the schema by writing update scripts and distributing them. Are there any tools which will take 2 known schemas and generate for us the update statements to upgrade one schema to the other? Or are there any tools at all to help us manage our changing schema at customers sites?

↪ replying to Wes Gray

John Carlson — Wed, 08 Dec 2004 22:20:31 -0500 — source: Usenet: comp.databases.informix

On Wed, 08 Dec 2004 19:27:58 GMT, Wes Gray <linuxwes_nospam@yahoo.com> wrote: >We have a large schema which we give to our users. Regularly we also >modify the schema by writing update scripts and distributing them. >Are there any tools which will take 2 known schemas and generate >for us the update statements to upgrade one schema to the other? >Or are there any tools at all to help us manage our changing schema >at customers sites? Might need to check out 'dbdiff' in the IIUG repository . . . JWC

↪ replying to Wes Gray

gary — 9 Dec 2004 01:58:21 -0800 — source: Usenet: comp.databases.informix

You can have a look at Server Studio JE It has GUI-based dbdiff and synchronization script generator as well as a bunch of other schema management utilities for Informix. You can download it from: www.serverstudio.com Wes Gray wrote: > We have a large schema which we give to our users. Regularly we also > modify the schema by writing update scripts and distributing them. > Are there any tools which will take 2 known schemas and generate > for us the update statements to upgrade one schema to the other? > Or are there any tools at all to help us manage our changing schema > at customers sites?