Firebird 5 Furthermore, you should be aware that Firebird 5 can open Firebird 4 databases, and even upgrade them, from ODS 13.0 to ODS 13.1, but won’t open databases that were created by Firebird 3 or older security database, it is also possible to copy the security4.fdb to security5.fdb and use gfix -upgrade to upgrade from ODS 13.0 to ODS 13.1, but we recommend using the backup and restore route (if only so database security2.fdb. Firebird 5 comes with a SQL script security_database.sql (located in misc/upgrade/v3.0) that will recreate users in the Firebird 5 security database, preserving all information except

non-ASCII data then the backup/restore cycle is not enough to upgrade them to ODS 11.1. Please pay attention to the files in the /misc/upgrade/metadata directory of your Firebird 2.1 installation. Running database files. The security database is renamed to security2.fdb If you upgrade an existing installation, be sure to upgrade the security database using the provided script in order to keep your existing chapter on security in the accompanying Release Notes. Also read the file security_database.txt in the upgrade directory beneath the root directory of your installation. Trusted Authentication on Windows (V

regression; if you use it, upgrade to 2.0.3 or higher ASAP and make sure to read your new version's Release Notes. • If you want to rely on Linux forced writes to work correctly, upgrade to at least 2.0.4. no reason to categorically prefer one to the other. Of course you may have your own specific considerations. If you install Firebird under Windows 95/98/ME, uncheck the option to install the Control Panel order to keep the existing accounts available. Consult the Release Notes for instructions on how to upgrade old security databases. If the error message starts with “Cannot attach to services manager”, the

all the tables, or one generator for each table. This is up to you — but take the following considerations into account. With the “one for all” approach, you: • + need only a single generator for all

used by later versions of Firebird to restore the database, however, while this may result in an upgrade to the On Disc Structure (ODS) for the database in question, the SQL Dialect will never be changed corrections to meta data and data, respectively, during the process of restoring a database for upgrade. 4.3. Speeding up the Restore The restoration of a database, from a backup, can be made to execute setenv_firebird 2.1 Firebird environment set for version 2.1. tux> # Recreate the database and upgrade the ODS. tux> gfix -shut -tran 60 employee tux> gbak -replace /backups/employee.2_0.fbk employee

To roll changes back to the savepoint, the statement ROLLBACK TO SAVEPOINT is used.  Memory Considerations The internal mechanism beneath savepoints can consume large amounts of memory, especially if

NULL handling, run the script ib_udf_upgrade.sql Chapter 13. User-Defined Functions (UDFs) 39 against your database. It is located in the Firebird misc\upgrade\ib_udf directory. 13.4. Being prepared

обработки значений NULL, то выполните для Вашей базы данных скрипт ib_udf_upgrade.sql из каталога \misc\upgrade\ib_udf директории установки Firebird. Максимальное количество индексов в различных

out. So if you're in one of these situations: • You use Firebird 1.0 or 1.0.2 and don't want to upgrade to at least 1.0.3; or • You run Firebird under Windows 9x or ME and you still want a handy applet

Datenbanken führen. Obwohl diese Probleme nicht häufig auftreten, sind sie schwerwiegend genug, um ein Upgrade auf Firebird 2.0.4 oder höher zu rechtfertigen, wenn Sie nbackup bequem verwenden möchten. Wenn