ODS (on-disk structure) is a number representing version of the database physical layout structure. When a new feature is added to the Firebird it might or might. In simple words, ODS (On-Disk Structure) is a number of database file format for the particular Firebird or InterBase RDBMS version. Almost all. Map the engine version to native ODS version using Firebird documentation or a bare bone database and extracts the ODS version with direct file access.

Author: Akinosho Zulkitaxe
Country: Russian Federation
Language: English (Spanish)
Genre: Education
Published (Last): 26 February 2006
Pages: 381
PDF File Size: 9.45 Mb
ePub File Size: 18.71 Mb
ISBN: 745-2-46549-921-6
Downloads: 71693
Price: Free* [*Free Regsitration Required]
Uploader: Zoloshicage

If gstat will not understand read information, it will show corresponding message — what it expected, and what it found. What is ODS version and how to retrieve it? Firebird Migration service Often the migration the complex firrebird, especially for legacy Firebird databases, which were abandoned by original developers.

All Firebird and InterBase On-Disk-Structure (ODS) versions

This need to be done to check if there any bad old metadata in your database or bugs of script extraction in the server you use. User and password here unnecessary, because gstat with —h option just read physical part of the database header page, number 0.

In order to work with a database with an older ODS it will be necessary to make a backup using gbak under the older server and restore it with gbak on Firebird 3. To learn more, visit our add content page. Sometimes you can get another kind of message, from the server not from gstat but with the same meaning. Currently, after 13 years of Firebird and InterBase development, migration between the latest versions of these servers is pretty difficult. It will show something like.

For information about authentication mapping, see Mapping of Users to Objects in the Security chapter. The ODS version, as reported by user tools, shows with which server version the database was created, e. This makes the new limit roughly equal to 2. There’s no way to know it upfront. To retrieve it you can use the Firebird API, or simply use the tool that reads it for you it’s on properties page of each database in FlameRobin. Initially in Firebird 3.

It is dangerous to work with ODS 9.

FreeAdhocUDF ODS-versions

Anyway, if you try to do this, you need to extract metadata script from the database, and then try to create the new database from that script, using the same server. If it does, the ODS number must increase. If you only have command-line access you can use Firebird’s gstat command line tool located in bin directory. Protocol and client library version. Per-table performance counters have been added to all of the monitoring tables.

If you only have remote connection to the server and you can log into the database, but you have no access to the database file itself, then starting with Firebird 2. Wrong ODS version, expected 11, encountered 15 — Firebird 2. Wrong ODS cirebird, expected 8, encountered 13?

As previously, Firebird will not open a database on little-endian that was created on big-endian, nor vice versa. For example, ODS 9. Note A legacy provider for databases with ODS 8 to Our checks did not reveal any cross-platform compatibility issues between ODS Example of use “Database Properties” in: The difference between ODS major or minor can be huge, or small.

ODS on-disk structure version is a number representing version of the database low-level data layout structure ODS. Our oods offers the comprehensive migration service for the complex Firebird databases.

If you made the backup before server upgrade, there will be no problems to return back. Connect to any database that you can Check the engine fiebird – http: When a new feature is added to Firebird it might or might firsbird require the structure of database pages or system tables database metadata to change. This allows the server to work with database files from previous versions and simplify the transition from the old server to a new one.

Chapter 4: Changes to the Firebird API and ODS

This number is checked upon connection, so that server makes sure it can ‘understand’ the database structure. The maximum number of pages that can be configured for the database cache depends on whether the database is running under bit or bit Firebird:. They were carefully checked to verify that, for them, there is no actual difference between ODS Databases created with bit and with bit builds of Firebird 1.

Post Your Answer Discard By clicking “Post Your Odz, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of dos website is subject to these policies.

What is ODS version and how to retrieve it?

Prior to Firebird 3. For example, if you open a database with Odss 8. The three ID fields are just for information: For non-Windows and non-Intel-Linux platforms, developers could not perform all the required checks. For example, if we run gstat from InterBase 4 at database from Firebird 2, it will show Wrong ODS version, expected 8, encountered ?

Map the engine version to native ODS version using Firebird documentation or knowledge base articles like http: It will show something like can’t format message The PLAN is now included.

Its option -h outputs the header page information, which contains the ODS: Wrong ODS version, expected 11, encountered 11 — Firebird 2.

If you haven’t used any new features of server X version of InterBase or Firebirdso you may return to X-1 following these steps: