RE: Record of Table Changes ~ Answered: amber (hollow confidence) — Single-message thread that is a mis-threaded duplicate of thread 10671 (re-quotes Art Kagel's dbschema/version-control answer verbatim, plus an off-topic sarcastic aside about AGS pricing); no independent confirmation in this fragment.

Advisory only.

Not to knock AGS, but why pay for something when you can get it for free? I mean what are you paying your DBAs or Sysadmins for? Yeah that's the ticket. Informix DBAs, the new prop winders in the jet age.... ;-) From: art.kagel@gmail.com Date: Thu, 10 Dec 2009 10:14:11 -0500 Subject: Re: Record of Table Changes To: red_valsen@yahoo.com CC: informix-list@iiug.org No. IDS does not keep track of schema changes in any form that's accessible to you. There is an internal record of outstanding prior versions of tables that have incomplete in-place alters outstanding, but you can't get at the older versions, only the current one. You can, as Gumby suggests, have a cron (or server scheduled task in 11.xx) that periodically runs dbschema (or myschema for that matter) and submits the file to a version control system like sccs, rcs, cvs, subversion, etc. There is another option, if you are using AGS Server Studio and Sentinel. Server Studio can maintain a change history for you using Sentinel's capabilities to perform the periodic schema check and record the changes over time. This is an advanced feature, but if you want to play with it, download SS and Sentinel v7.0 from AGS's site (www.serverstudio.com) and get a trial license for the Change Management Edition or the Suite Edition and see if it's worth buying licenses. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Dec 10, 2009 at 9:27 AM, red_valsen@yahoo.com <red_valsen@yahoo.com> wrote: Does the DBMS keep a persistent record of data structure changes to tables in a format that is humanly accessible? For example, if a table has 4 different versions, how would I be able to determine what each of those changes was? Yes, this has been posted before (but not answered). Using IDS 11.50 on HPUX & RHL _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Windows 7: Unclutter your desktop. Learn more. http://www.microsoft.com/windows/windows-7/videos-tours.aspx?h=7sec&slideid=1&media=aero-shake-7second&listid=1&stop=1&ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_7secdemo:122009