dhis2-users team mailing list archive

[Mark Spohr <mhspohr@xxxxxxxxx>]

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