Migrate current database

From TBwiki

Revision as of 13:41, 4 January 2019 by Luc Morissette (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Note: This checkbox will be available starting from v2.7.148 in Activate package section when doing a major upgrade from web portal.

Select Migrate current database in the Activate package section

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.

Prior to version 2.8, database is named as toolpack_0 (for example for current system version if it is 2.7). For 2.8 and above, database is named as toolpack_2_8, toolpack_2_9, accordingly.