dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
>
>> On Mon, Oct 10, 2011 at 10:02 PM, Mark Spohr <mhspohr@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>> 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