Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-30 Thread Chameera Mirihella
Hi Json, Thanks for the information. We are doing the same thing as you suggested. after db migration to postgres, we go version to version and treat the errors come on the way. there were issues in boolean type and null values as you said and fixed. one thing i wanted to ask from you. we are

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-30 Thread Chameera Mirihella
Hi Halvdan, yes it is a good collection, we use one tool suggested by it to do the initial migration. but that is not enough, have to do some modifications in the schema manually to bring it back to the dhis schema. Hi Knut, I agree with your suggestion but as you said it is one-time job. In our

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-29 Thread Jason Pickering
Hi Chameera, I did not really use any scripts for this process when I upgraded a very old version (although it was not 2.6) . Like I said, it went pretty well. I monitored both the Tomcat log as well as the Postgresql database log during startup, and resolved the problems as they arose. In

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-29 Thread Knut Staring
Switching databases is another use case for trying export and import. But the emphasis is on trying, not sure how much exists in terms of ready scripts that take care of everything. Jason does a lot of R scripting. Using Node and the web api is yet another approach. Ideally we should build up a

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-29 Thread Halvdan Hoem Grelland
There is a fairly in-depth collection of resources on migrating to PostgreSQL on the official PostgreSQL wiki On Fri, Jul 29, 2016 at 12:03 PM, Chameera Mirihella wrote: > Hi Jason, >

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread Jason Pickering
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

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread Bob Jolliffe
Gerald I assume that you are going to try this out on a test machine, not the machine on which the users are entering data. On 27 July 2016 at 13:54, gerald thomas wrote: > Thanks Knut, they are currently doing data entry till August 15. I will > start on the 16 or 17 and

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread gerald thomas
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" wrote: > I suggest you try with 2.16 and let us know how it goes. If problematic, > then try a few versions

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread Knut Staring
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" wrote: > Dear Knut, > Noted!!! > I noticed that upgrade procedures' starts from version 2.16 and the oldest > war file

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread gerald thomas
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

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread Knut Staring
Try with everything first. If it doesn't work, start with building blocks such as categories and orgunits, depending on the types of problems you encounter. Unfortunately, I doubt anyone has a complete recipe for how to do this, some experimentation and ad hoc fixes may be required. If you get

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread Knut Staring
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

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-27 Thread gerald thomas
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

Re: [Dhis2-devs] [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

2016-07-26 Thread Knut Staring
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" wrote: > Dear All, > I am inquiring for both technical guidance and materials to