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 <chameera9...@gmail.com > 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.picker...@gmail.com> 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 <gerald17...@gmail.com> >> 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" <knu...@gmail.com> 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" <gerald17...@gmail.com> 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" <knu...@gmail.com> 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" <gerald17...@gmail.com> 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" <knu...@gmail.com> 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" <gerald17...@gmail.com> >>>>>>>> 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-us...@lists.launchpad.net >>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>> >>>>>>>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-us...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> -- >> Jason P. Pickering >> email: jason.p.picker...@gmail.com >> tel:+46764147049 >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : dhis2-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > 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/>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp