Differences

This shows you the differences between two versions of the page.

--- tutorials:mairlistdb:sql-client-setup [2017/09/19 07:09] – [Additional Client Computers] tw
+++ tutorials:mairlistdb:sql-client-setup [2019/07/09 16:18] (current) – external edit 127.0.0.1
@@ Line 59: / Line 59: @@
 ===== Schema Upgrade =====
+When you install a new version of mAirList, it can happen that the mAirListDB connection stops working, and you see a message similar to the following:
+  Invalid schema version (found xx, need yy). Please upgrade your database.
+This happens when the new software version to add or modify SQL tables to support new functionality. We must perform a **Schema Upgrade** then.
+<WRAP warning round>
+**BIG FAT WARNING**:
+Once the database schema was upgraded to a new version, it will stop working with older clients (mAirList versions) that require the older schema version. So you must also install the same new software version on **all** mAirList computers.
+**It is not possible to downgrade the schema to an older version once it was upgraded.** We strongly recommend that you make a backup of your database before performing the upgrade, in case you must roll back to the old software version for any reason.
+</WRAP>
+To perform the schema upgrade, go to the //Upgrade// tab in the mAirListDB connection properties dialog. **You must do this only once for each database.**
+First, click the //Check now// button to find out what your current schema version is, and if it matches the required version.
+If an upgrade needs to be performed, click //Upgrade// and wait for the upgrade to complete.
 ===== Optional Configuration Tasks =====