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
