Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- en:installation_und_deinstallation:migration_nach_5 [2026/04/22 10:10] – angelegt admin
+++ en:installation_und_deinstallation:migration_nach_5 [2026/06/16 10:00] (aktuell) – admin
@@ Zeile 1: / Zeile 1: @@
-======Migration of a Firebird 2.5 Database to a Firebird 5 Database======
+======Migrating a Firebird 2.5 Database to a Firebird 5 Database======
+You can find the current PAM version **[[pam|here]]**.
 =====Background=====
-Since 2026-04-17, the Firebird vulnerability CVE-2026-40342 has been publicly known. To avoid potential risks, we recommend that you **uninstall** the currently installed Firebird version as soon as possible and switch to the current version.
+Since 17 April 2026, the security vulnerability CVE-2026-40342 has been known for Firebird. To avoid potential risks, we recommend that you promptly **uninstall** the currently installed Firebird version and switch to the latest version.
-Please then install the following version: **Firebird 5.0.4 for Windows x64** https://www.firebirdsql.org/download-file?file=https://github.com/FirebirdSQL/firebird/releases/download/v5.0.4/Firebird-5.0.4.1812-0-windows-x64.exe
-Please note that the PAM database currently still has to be migrated to the new system **manually**.
-Unfortunately, automatic migration is not yet available at this time.
-=====Manual Migration=====
-Please perform the migration as follows:
-====Install Firebird 5.0====
-Install Firebird 5.0 using the default settings. Please make a note of the assigned SYSDBA password (referred to below as: mySYSDBA_PASSWORD).
-====Download Firebird 2.5 portable====
+Please then install the following version: **[[https://www.firebirdsql.org/download-file?file=https://github.com/FirebirdSQL/firebird/releases/download/v5.0.4/Firebird-5.0.4.1812-0-windows-x64.exe | Firebird 5.0.4 für Windows x64]]**
-To migrate Firebird 2.5 databases, a running Firebird 2.5 server is temporarily required. For this purpose, please download the portable version of Firebird 2.5 https://www.firebirdsql.org/download-file?file=https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/Firebird-2.5.9.27139-0_Win32.zip and extract it, for example, to **C:\FB25**.
+===== Automated Migration =====
-====Adjust the firebird.conf file====
+Automated database migration is available starting with version **[[pam|PAM 3.1.2]]**.
-Open the file C:\FB25\firebird.conf and change the following line:
+First, make sure that **Firebird 2.5 32-bit** has been uninstalled and that **[[https://www.firebirdsql.org/download-file?file=https://github.com/FirebirdSQL/firebird/releases/download/v5.0.4/Firebird-5.0.4.1812-0-windows-x64.exe | Firebird 5.0.4 für Windows x64]]** is installed.
-''#RemoteBindAddress ='' to ''RemoteBindAddress = 127.0.0.1''
+To migrate your material databases from Firebird 2.5 to Firebird 5, please use the wizard in PAM Material Database Management. To do this, click **Databases** in the menu and then **Update to new Firebird version**.
-This ensures that the server is only accessible locally.
+{{ :installation_und_deinstallation:de_pam_auto_mig_001.png?nolink |}}
-====Copy the existing security database====
+Then enter the administrator password for the user **sysdba**.
-If Firebird 2.5 was previously installed, please copy the file ''C:\Program Files(x86)\Firebird\Firebird_2_5\security2.fdb'' to ''C:\FB25\security2.fdb''.
+{{ :installation_und_deinstallation:de_pam_auto_mig_002.png?nolink |}}
-====Start the Firebird 2.5 server====
+You will now see the databases listed in PAM that require migration. Then click **Start**.
-{{ :installation_und_deinstallation:de_gbak_001.png?nolink&1000 |}}
+{{ :installation_und_deinstallation:de_pam_auto_mig_003.png?nolink |}}
-Open a PowerShell window and execute the following steps:
+Open the Task Manager and stop the **FirebirdServerDefaultInstance** service.
-  * ''cd C:\FB25\bin\''
-  * ''$env:FIREBIRD="C:\FB25"''
-  * ''.\fbserver.exe -a''
-====Perform the database migration====
+{{ :installation_und_deinstallation:de_pam_auto_mig_004.png?nolink |}}
-{{ :installation_und_deinstallation:de_gbak_002.png?nolink&1000 |}}
+Then restart the **FirebirdServerDefaultInstance** service.
-Open a **second PowerShell window** and execute the following commands:
+{{ :installation_und_deinstallation:de_pam_auto_mig_005.png?nolink |}}
-  * ''C:\FB25\bin\gbak.exe -backup -user sysdba -password oldMASTERKEY 'c:\OLD_DATABASE.GDB' temp.txt''
-  * ''& 'C:\Program Files\Firebird\Firebird_5_0\gbak.exe' -c -v -user sysdba -password mySYSDBA_PASSWORD .\temp.txt 'c:\NEW_DATABASE.GDB'''
-The following applies:
+Once the databases have been migrated successfully, the status changes to **Success**. You can then close the wizard.
-  * oldMASTERKEY is the SYSDBA password in Firebird 2.5
-  * mySYSDBA_PASSWORD is the password assigned during the Firebird 5.0 installation
-  * c:\OLD_DATABASE.GDB is the **existing** database in Firebird 2.5 format (for example: C:\Users\Public\Documents\KTP\PAM\Databases\PAM31se.GDB)
-  * c:\NEW_DATABASE.GDB is the storage location of the **new migrated** database (for example: C:\Users\Public\Documents\KTP\PAM\Databases\PAM31se_new_fb5.GDB)
-**This step can be repeated for multiple databases if required.**
+The material databases are now available to you again.
-====Stop the Firebird 2.5 server====
+{{ :installation_und_deinstallation:de_pam_auto_mig_006.png?nolink |}}
-After the migration has been completed, please stop the Firebird 2.5 server with the following command: ''taskkill /im fbserver.exe''