...
After moving to newer version of Mifos, can I wait a week or longer to run db contraction?
Yes. Db contraction needs to happen anytime before next Mifos upgrade. It is a mandatory step in production and must be planned for.
How does do we do db upgrade work in test servers?
For most of the testing purposes like story sign offs, we can rely on tomcat start up for the db upgrade. The shell scripts used in production is used in CI for db expansion. Rollback scripts and windows batch files are not part of any automated teststesting. Its It is recommended to do one round of manual test with these scripts before a release.
I have created a change set, can I see the SQL equivalent generated by Liquibase?
Before applying to change set on the db, run "mvn liquibase:updateSQL" from db module. This step generates the SQL for un-applied upgrades and saves it to a file without upgrading db.