It's highly recommended to take database backup before upgrading mifos x.
At the time of upgrading mifos x to latest version if you get the error log as " Migration of schema failed. Like in the below shown example in screen shot:-
You should follow below mentioned steps as mentioned below to fix the issue:-
I am using the same example that is Migration of schema `mifostenant-default` to version 251 failed!
Step 1)
In this example I am upgrading to Mifos X 15.03.1v
Go to downloaded mifos x folder i.e
Step 2)
Go to path: mifosplatform-15.03.1.RELEASE\database\migrations\core_db >> then to the failed version, in this example to V251
Step 3:
Open the sql script in text editor like notepad++
Step 4:
Please copy the script one by one till the semi-colon (;), like showed in the below screen shot:
Step 4: For easy use - mysql I have used heide sql (http://www.heidisql.com/download.php)
Follow below mentioned steps
1) Go to the failed database in this example it is `mifostenant-default` and click on it.
2) Click in query tab
3) Paste the copied script (1) from the above shown example
4) Click on > button which will run the script.
If the table already exists it will give the same error message.
Continue doing the same steps for all other scripts till the
Related articles