Differences

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

--- tutorials:mairlistdb:sql-client-setup [2017/09/19 07:07] – [Additional Client Computers] tw
+++ tutorials:mairlistdb:sql-client-setup [2019/07/09 16:18] (current) – external edit 127.0.0.1
@@ Line 57: / Line 57: @@
 Each mAirListDB has a unique identifier (made up of several random hexadecimal characters), the "Database ID". The ID is stored in the ''config'' table inside the SQL server, and also in the ''database.ini'' file of each client PC. It will help mAirList to identify the correct connection if you happen to maintain connections to more than one mAirListDB at a time. Clicking //Yes// in this dialog will retrieve the ID from the SQL table and store it in the local configuration. (You can look it up on the //Advanced// tab in the connection properties dialog if you like.)
+===== 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 =====
+==== Connection Options ====
+==== Multi-User Setup and Security Roles ====
+==== Storage Redirection ====
+==== Maintenance ====