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 <mhsp...@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 <knu...@gmail.com> wrote: > >> On Mon, Oct 10, 2011 at 10:02 PM, Mark Spohr <mhsp...@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 >> http://hisp.uio.no >> +4791880522 >> >> > > > -- > Mark Spohr, MD > > -- Knut Staring Informatics, U. of Oslo http://hisp.uio.no +4791880522
_______________________________________________ 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