Hi Robert I don't think this is a live system we are discussing here. I
think it's an old db I sent that may not be 100% compatible with that code
as many of the versions have slightly different db structures. It is just a
case of working through them
Thanks
Tim
Course View Towers,
Plot 21 Yusuf Lule Road,
Kampala
T +256 (0) 312 314 418
M +256 (0) 752 963 325
www.weberpafrica.com
Twitter: @TimSchofield2
Blog: http://weberpafrica.blogspot.co.uk
On 24 Mar 2016 09:56, "Robert Meggle" <robert.meg...@care2x.org> wrote:
> Hello Sovello, nie to hear from you. :)
>
> This is extremely difficult challenge and depends on the change itself
> how I would go for it. The issue is, that these data are in production
> use and you don't have any "playground" anymore like during development.
> Backup first! My paranoid aspect: If you have never restored this
> backup, you don't have any backup.
>
> How to do the change?
>
> In some cases I use simple (SQL/bash/perl/...) scripts.
>
> In more complex events or if it is foreseeable that there are data
> transformations to be done, such like merging columns, dividing one
> table information into "n" other related tables etc. I always using
> pdi/kettle:
> http://community.pentaho.com/projects/data-integration/
> Works with nearly all common databases. And you have the option to start
> it from an update script. Java runtime is required for PDE. Maybe even
> JDE, don't know, because I have it always.
>
> This is a tool for ETL (Extract, transform and load data). Yes, you can
> do the same with conventional programming or scripting languages. But I
> recognized that it save time to use such ETL tools.
>
> So a bit difficult to say. Can you explain a bit more what the challenge
> is?
>
> Cheers
> Robert
>
> Am Donnerstag, den 24.03.2016, 08:58 +0300 schrieb Sovello Hildebrand
> Mgani:
> > Hi everyone!
> > How do we update a Care2x database table when the system is already
> > installed.
> > I came to realize that some of the fields though available in the
> > module class (e.g. class_lab.php) but are missing in the actual tables
> > associated with the class.
> > I want to be able to update the tables after the instance has been
> > installed.
> > Any pointers will be highly appreciated!
> >
> > Cheers
> >
> >
> ------------------------------------------------------------------------------
> > Transform Data into Opportunity.
> > Accelerate data analysis in your applications with
> > Intel Data Analytics Acceleration Library.
> > Click to learn more.
> > http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
> > _______________________________________________
> > Care2002-developers mailing list
> > Care2002-developers@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/care2002-developers
>
> --
> --------------------------------------------
> MEROTECH IT Engineering
>
> Robert Meggle
> St.-Mang-Str. 8
> 87616 Marktoberdorf
>
> Germany
>
> UstNr.: DE232073735
> Tel: +49(0)8342 - 8956729
> Fax: +49(0)8342 - 8956730
> mailto:meg...@merotech.de
>
>
>
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
> _______________________________________________
> Care2002-developers mailing list
> Care2002-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/care2002-developers
>
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
