Our database is fully SQL compliant and as long as you have a softare (ODBC, JDBC, REST) that supports DDL syntax, you can manage database schema. Some apps like to hide that part and only allow a subset or predefined schema but as far as supporting informix, it is very open. Maybe I missed the question. what is it you are trying to change schema-wise?
Hi @donhutchinson, I'm the DBA which is responsible to manage the company databases (Informix, Oracle, SqlServer). Our main system is with 4GL and we have our own development team to adjust and adapt the system as company needs (we are an Industry, not software company). The analysts define the changes over the schemas then I review this changes, apply the technical adjustments and effectively apply at our databases. We need an way to control the changes occurred . Resources like described below will be very welcome. Most important, support Informix specific syntax (consider "-ss" parameter of dbschema and others specific DDL commands like 'rename' , alter fragment, etc). - Control versions , such like a SubVersion control a source code. - Able to create the DDL of specifics snaphosts (situation at day X). - Able to create an "alter" script between two days of specifics objects or an entire database. - Add comments for each change commited... - Allow customize fields to fill for each change. eg.: a field to inform the Ticked of our support system and this way able to filter changes of certain ticket. - Work with others databases too... (this is why I'm looking for a open source tool) keep centralized all this control for all database vendors into the same tool . Which refer about Informix syntax, I think the Server Studio from Advanced Tools is awesome ... but it's very expensive and work only with Informix. By the way, if you know about any other tool to create a dictionary data (descriptions of tables and fields) I appreciate any tip too (since the engine don't support this natively like DB2)
Cesar: Between dbschema and my replacement utility myschema you have good tools for getting the current DDL for a database. As far as a repository, you can store those DDL files in any source code repository including Subversion., CVS, etc. As for a tool to create ALTERs to get from one schema to the next, you can look at AGS's Server Studio and also Sentinel. Those are, of course, commercial products and not Open Source. However, SS does provide a mechanism to compare two schema and generate an ALTER statement to get from one to the other. This can be used to beat the production schema against the development schema to produce the ALTER scripts to update production. Also, Sentinel has an automatic feature that monitors the live schema and makes a recording and optionally sends an alert anytime the schema changes. The recording is audit quality and secured.
Hello Cesar, Sorry for the late answer, I just joined this forum a few days ago. If you are a 4GL programmer, you may want to have a look at FOURJS tools. Check Genero at www.4js.com, and https://github.com/FourjsGenero/tool_fglschmg ... The fglschmg tool is written in Genero BDL, and you can adapted it to your needs. We have also Genero Studio, which includes a database management tool. Seb
Cesar: AGS's Server Studio supports this functionality and automates schema change detection if you also have Sentinel. See www.serverstudio.com