Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- en:installation_und_deinstallation:migration_nach_5 [2026/04/23 14:02] – 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: **[[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 for Windows x64]]**
-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.
-You currently have three options:
-  - [[:installation_und_deinstallation:migration_nach_5#lokale_nutzung|Continue using Firebird 2.5.9 with local material databases (Local Use)]]
-  - [[installation_und_deinstallation:migration_nach_5#manuelle_migration|Switch to Firebird 5.0.4 and manually migrate the material databases (Manual Migration)]]
-  - [[installation_und_deinstallation:migration_nach_5#automatisierte_migration|Uninstall Firebird 2.5.9 and wait for the new PAM version with automated migration]]
-===== Local Use =====
-Open the file ''C:\Program Files (x86)\Firebird\Firebird_2_5\firebird.conf'' and change the line:
-''#RemoteBindAddress =''
-to
-''RemoteBindAddress = 127.0.0.1''
-This ensures that the server is only accessible locally.
-=====Manual Migration =====
-Please perform the migration as follows:
-====1. Uninstall Firebird 2.5.9====
-Please first uninstall Firebird 2.5.9.
-====2. 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).
-====3. 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**.
-====4. Adjust the firebird.conf file====
+===== Automated Migration =====
-Open the file C:\FB25\firebird.conf and change the line:
-''#RemoteBindAddress =''
+Automated database migration is available starting with version **[[pam|PAM 3.1.2]]**.
-to
+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 = 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. Network databases will then no longer be accessible.
+{{ :installation_und_deinstallation:de_pam_auto_mig_001.png?nolink |}}
-====5. 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 |}}
-====6. 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 the Task Manager and stop the **FirebirdServerDefaultInstance** service.
-Open a PowerShell window and execute the following steps:
+{{ :installation_und_deinstallation:de_pam_auto_mig_004.png?nolink |}}
-  * ''cd C:\FB25\bin\''
-  * ''$env:FIREBIRD="C:\FB25"''
-  * ''.\fbserver.exe -a''
-====7. Perform the database migration====
+Then restart the **FirebirdServerDefaultInstance** service.
-First, copy the database to be migrated into the temporary folder, for example C:\FB25.
-{{ :installation_und_deinstallation:de_gbak_002.png?nolink&1000 |}}
+{{ :installation_und_deinstallation:de_pam_auto_mig_005.png?nolink |}}
-Open a **second PowerShell window** and execute the following commands:
+Once the databases have been migrated successfully, the status changes to **Success**. You can then close the wizard.
-  * ''C:\FB25\bin\gbak.exe -backup -user sysdba -password oldMASTERKEY 'C:\FB25\OLD_DATABASE.GDB' backup_db.txt''
-  * ''taskkill /im fbserver.exe''
-  * ''& 'C:\Program Files\Firebird\Firebird_5_0\gbak.exe' -c -v -user sysdba -password mySYSDBA_PASSWORD .\backup_db.txt 'C:\FB25\NEW_DATABASE.GDB' ''
-The following applies:
-  * **oldMASTERKEY** is the SYSDBA password in Firebird 2.5
-  * **mySYSDBA_PASSWORD** is the password assigned during the Firebird 5.0 installation
-  * **C:\FB25\OLD_DATABASE.GDB** is the **existing** database in Firebird 2.5 format (e.g. C:\Users\Public\Documents\KTP\PAM\Databases\PAM31se.GDB)
-  * **C:\FB25\NEW_DATABASE.GDB** is the storage location of the **new migrated** database (e.g. 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.
-=====Automated Migration=====
+{{ :installation_und_deinstallation:de_pam_auto_mig_006.png?nolink |}}
-Automated migration of the databases is currently not yet possible. Appropriate solutions are **currently** under development and are expected to be available with version **PAM 3.1.2**.