Migrate current database

When upgrading the system to a new version, there is an option to create the current configuration in the new version. This is usually the desired way and will be done automatically.

Select Migrate current database in the Activate package section

From the Web portal, select "Packages and Licenses" under the Maintenance section.

Select Migrate current database in the Activate package section

Migrate current database clarification

• When upgrading to the next major software version, and this next major software version had not been upgraded before (for example, 2.7.148 -> 2.8.132, and 2.8.132 had not been upgraded for this system before), it does not matter to check on this Migrate current database checkbox or not. It it recommended to check and enable it for simplicity.

• If from above example, 2.8.132 had been upgraded before for this system, and some reason user had downgraded again to current lower major software 2.7.148, then user will have the choice when doing a major upgrade again whether to discard or keep the change made in 2.7.148 (while in 2.7.148 after downgraded from 2.8.132), and say, to 2.8.132 (as example from above, can be other higher versions) with previous database of 2.7.148 that containing the previous configuration after completing upgrade to 2.8.132. Since discarding any change while in one software version is uncommon, it is recommended to check on this Migrate current database checkbox to migrate/clone the current database to next major softwar version keeping the change made in current software version. If Migrate current database is not checked, then a fresh database in 2.8.132 will be built.

• For downgrade, same concept as upgrade above that database will be cloned back to lower version database. But since, higher database structure may be different from lower version database structure perhaps with more fields, then when checked and downgrade, some data may be lost. So, when doing downgrade, it is recommended not to check this Migrate current database.

• Note that when doing a major upgrade, the current database of current software version will be backup/untouched, in case when there is a need to fall back to this current version at original stage.

Migrate current database diagrams illustration

No change at A at original software version 2.8, Migrate current database is not relevant (check for simplicity)

A changed to B at original software version 2.8, different Migrate current database scenarios

Changed to B at upgraded software version 2.9, no Migrate current database checked

Useful Links

Database backup