dhis2-users team mailing list archive

[Halvdan Hoem Grelland <halvdan@xxxxxxxxx>]

There is a fairly in-depth collection of resources on migrating to
PostgreSQL on the official PostgreSQL wiki
<https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL>

On Fri, Jul 29, 2016 at 12:03 PM, Chameera Mirihella <chameera9019@xxxxxxxxx
> wrote:

> Hi Jason,
>
> HISP India is also in the process of upgrading dhis from 2.7 to 2.23. are
> there any upgrade scripts available for earlier versions (2.7 - 2.16) ?
>
> and also the biggest challenge for us right now is that 2.7 instance run
> with mysql db, we need to convert it to postgres somewhere in this process.
> any suggestion is appreciated.
>
> Thanks.
>
> On Wed, Jul 27, 2016 at 6:37 PM Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Hi Gerald,
>>
>> I upgraded a system recently from 2.10 to 2.22, and it went pretty well
>> actually. There are some things you need to look out for along the way,
>> particular changes in the model, like duplication in orgunit groups, unique
>> (or non-unique codes) etc. I found it useful to turn on the Postgresql
>> logging during the process as certain errors may only be clearly visible in
>> the logs of the database, and not always through DHIS2.
>>
>> Most versions seem to be availble from
>>
>> https://www.dhis2.org/download/releases/2.XX/dhis.war
>>
>> where XX is the version which you need. Otherwise, you may need to build
>> it from source code.
>>
>> I do agree with Knut, that attempting an export /import to something like
>> 2.12 might be a good start,but this has lots of limitations, so a
>> step-by-step upgrade would be the best way.
>>
>> Regards and good luck,
>> Jason
>>
>>
>> On Wed, Jul 27, 2016 at 2:54 PM, gerald thomas <gerald17006@xxxxxxxxx>
>> wrote:
>>
>>> Thanks Knut, they are currently doing data entry till August 15. I will
>>> start on the 16 or 17 and i will keep you informed.
>>>
>>> On Jul 27, 2016 12:49 PM, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>>>
>>>> I suggest you try with 2.16 and let us know how it goes. If
>>>> problematic, then try a few versions earlier.
>>>> Knut
>>>>
>>>> On 27 Jul 2016 19:12, "gerald thomas" <gerald17006@xxxxxxxxx> wrote:
>>>>
>>>>> Dear Knut,
>>>>> Noted!!!
>>>>> I noticed that upgrade procedures' starts from version 2.16 and the
>>>>> oldest war file available is 2.7; which means I will have to work blindly
>>>>> till 2.16 by the grace of God.
>>>>> HISP India, please can you help because I heard you had done something
>>>>> like this before.
>>>>>
>>>>> On Jul 27, 2016 12:31 PM, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>>>>>
>>>>>> Gi Gerald,
>>>>>>
>>>>>> Please do not take my suggestion as a fully formed and fool-proof
>>>>>> procedure. But since you are exporting and then importing into an empty
>>>>>> instance of a newer version, you will not be messing up your existing data
>>>>>> (but should still take a backup first).
>>>>>>
>>>>>> Piecewise going through every version with the necessary database
>>>>>> updates is the safest route and to always be recommended.
>>>>>>
>>>>>> However, this might be difficult in this case, and certainly very
>>>>>> cumbersome. So I  suggest you give it a try. 2.16 was just a rough number,
>>>>>> I am not sure it will work,  but this method can help you skip a few
>>>>>> versions. However, you will have to test the results thoroughly, and
>>>>>> probably will run into a few obstacles. So it is not a silver bullet,  I'm
>>>>>> afraid.
>>>>>>
>>>>>> Knut
>>>>>>
>>>>>> On 27 Jul 2016 14:04, "gerald thomas" <gerald17006@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> Knut,
>>>>>>> That is a very big jump and if it works, it will make my day.
>>>>>>> As per your procedure, I should deploy the 2.16 war file on the
>>>>>>> newly installed DHIS2 with empty database "hmis" and do metadata export of
>>>>>>> everything from the old system which is running on 2.5 war file and finally
>>>>>>> import to the new instance?
>>>>>>> My question again Knut, what is the best method to do this export &
>>>>>>> import: piecewise or everything; if it is piecewise what should I import
>>>>>>> first, second,...... and last?
>>>>>>>
>>>>>>> Thanks for your help
>>>>>>>
>>>>>>> On Jul 26, 2016 15:40, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Hi Gerald,
>>>>>>>> I would try to skip a few versions by exporting metadata and data
>>>>>>>> and probably try to import to an intermediate version such as 2.13 or 2.16.
>>>>>>>>
>>>>>>>> On 26 Jul 2016 21:02, "gerald thomas" <gerald17006@xxxxxxxxx>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Dear All,
>>>>>>>>> I am inquiring for both technical guidance and materials to
>>>>>>>>> upgrade a
>>>>>>>>> DHIS2 instance from version 2.5 to 2.22.
>>>>>>>>>
>>>>>>>>> I will be grateful for any help anyone can render for me to
>>>>>>>>> successfully achieve this task. Also, i will like to know where i
>>>>>>>>> can
>>>>>>>>> get all the old war files.
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Regards,
>>>>>>>>>
>>>>>>>>> Gerald
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> 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
>>>>>>>>>
>>>>>>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>> _______________________________________________
>> 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
>>
>
> _______________________________________________
> 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
>
>


-- 
Halvdan Hoem Grelland
Software developer, DHIS 2
University of Oslo
http://www.dhis2.org <https://www.dhis2.org/>