Re: Record of Table Changes
IB my point was that if one has already licensed prior Suite releases of
SS/Sentinel - which has some change management features - then upgrading to
v7.0 is free and includes the extended change management feature. If you
have a lower level SS license, the upgrade to the CMO or Suite Edition is
cheap and some like the comfort of an integrated solution rather then
building it themselves.
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 10:21 AM, Ian Michael Gumby <im_gumby@hotmail.com>wrote:
>
> 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>;
>