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: Voodoorg Voodoozragore
Country: Slovenia
Language: English (Spanish)
Genre: Relationship
Published (Last): 14 August 2009
Pages: 220
PDF File Size: 4.54 Mb
ePub File Size: 16.17 Mb
ISBN: 866-5-93725-724-2
Downloads: 65552
Price: Free* [*Free Regsitration Required]
Uploader: Faukasa

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: The Implementation ID in the ODS of a database is deprecated in favour of a new field in database headers describing hardware details that need to match in order for the database to be assumed to have been created by a compatible implementation.

Currently we have only one flag, for endianness. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Check the engine version – http: Protocol and client library version. This can lead to the impossibility of returning to the version back. The compatibility flags are checked for a match between the database and the engine opening it.

It will show something like. Prior to Firebird 3. It is dangerous to work with ODS 9.

For example, when Firebird 1. For shared memory aka XNET protocol, it contained the local host name. The ODS version, as reported by user tools, shows with which server version the database was created, e. Then you can try to create a database from corrected script at the new server.

But that assumes that the database is at minimum ODS 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. Email Required, but never shown.


delphi – Querying ODS version in use from the Firebird Server – Stack Overflow

If your program can ensure those requirements, then it can work. Wrong ODS version, expected 8, encountered ? When a new feature is added to the Firebird it might or might not require the structure of system tables database metadata to change.

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 you are a commercial tool maker and your tool features a great way to handle the issue written about in this FAQ, please check out our advertisement oss.

For example, we have migrated the database which SQL script was 55 Megabytes, with more than stored procedures, tables and several thousands of ad hoc SQL queries, in less than 3 months. This allows the server to work with database files from previous versions and simplify the transition from the old server to a new one.

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. Post as a guest Name. The PLAN is now included. Here, you see ODS number — this is encoded 11, with the high bit added since Firebird 2. Connect to any database that you can Check the engine version – http: So, the minor upgrade of Firrebird makes incompatible databases within same major server version.

Sometimes, you may require performs a downgrade and return back from the new server.

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:. Historically, transaction ID space was limited to 2 31 transactions, counted from the time the database was created. Last versions of Firebird 3.


Our company offers the comprehensive migration service for the complex Firebird databases. Frebird the initial release, a database with an older ODS cannot be opened by Firebird 3. With the above technique, future versions of the Firebird server will also work, without the need to update the software. They were carefully checked to verify that, for them, there is no actual difference between ODS Thanks for all the comments.

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Note A legacy provider for databases with ODS 8 to Map the engine version to native ODS version using Firebird documentation or knowledge base articles like http: If you only have command-line access you can use Firebird’s gstat command line tool located in bin directory.

The most popular platforms—Windows and Linux x64 bit —were not affected by the change.

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

IB Surgeon Toggle navigation. 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 firebord in FlameRobin.

The difference between ODS major or minor can be huge, or small. Sign up using Email and Password.

What is ODS version and how to retrieve it?

If you made the backup before server upgrade, there will be no problems to return back. What is ODS version and how to retrieve it? It is likely to be abandoned in a future version. Initially in Firebird 3.