Hi Mark,
As Ola says, the use of dimensional breakdown (age, sex etc) will proabably also be a determinant of how easy this will be. Unfortunately, the changes have not been consistently documented in one place but typically spread over each release, but if your data is somewhat complex and the methods outlined don’t work out of the box, I would go for Ola’s offer to take a look, as he really is our resident expert.
As for H2, I suppose I would be a bit reluctant to use it for a central server (though not sure it couldn’t work even for that). In your setup, do you have a number of local/offline installations? If so, I think H2 could be a very good choice. I suppose the only things that go against it is that the DHIS2 community has not tested it as extensively as the other two (thus we would welcome your experiences) and that there are somewhat less 3rd party tools available to work with it, but it should be possible to use e.g. the Postgres ODBC driver, which opens up a large range of possibilities: http://www.h2database.com/html/advanced.html#odbc_driver
Knut
···
On Mon, Oct 10, 2011 at 10:39 PM, Mark Spohr mhspohr@gmail.com wrote:
Hi Knut,
Thanks for the information. The system was set up with Postgres. It only has one custom data entry form now. It was set up with facilities and provinces but not much else. However, a year’s worth of historical data was imported into the system from another database and some work remains to clean up that import.Is there some documentation of the changes to the DB across versions?
I think the DXF export/import process would probably be best.On a related note, most systems seem to use MySQL or Postgres but the H2 database seems quite capable and has good performance at the scale we anticipate (328 facilities monthly reporting) so any caveats if we decide to stay with H2?
All the best,
Mark
On Mon, Oct 10, 2011 at 1:14 PM, Knut Staring knutst@gmail.com wrote:
On Mon, Oct 10, 2011 at 10:02 PM, Mark Spohr mhspohr@gmail.com wrote:
I am working on a system which was originally set up with version 2.0.4 and wish to install the latest (2.4) .
Is there anything that needs to be done to upgrade the data for the new version? Will this be handled somehow?
Hm…there are quite a few changes between the two. I guess the best approach depends a bit on what exactly is in the current system, e.g. are there many custom data entry forms?
First of all, you could just do a dump and make a copy of the database (MySql or Postgres?), and run it with the latest and see what may be missing.
Another approach could be to try a DXF export and import into an empty 2.4 database (the structure will be generated if you link 2.4 to a completely empty database). However, not everything is included in DXF, so some additional manual adjustments are likely necessary.
Knut
Thanks,
Mark–
Mark Spohr, MD
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Knut Staring
Informatics, U. of Oslo
+4791880522
–
–
Mark Spohr, MD
–
Knut Staring
Informatics, U. of Oslo
+4791880522