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: Daizshura Dizilkree
Country: Armenia
Language: English (Spanish)
Genre: Spiritual
Published (Last): 6 April 2006
Pages: 423
PDF File Size: 12.52 Mb
ePub File Size: 20.67 Mb
ISBN: 236-5-18019-795-9
Downloads: 99151
Price: Free* [*Free Regsitration Required]
Uploader: Juzuru

Its option -h outputs the header page information, which contains the ODS: For non-Windows and non-Intel-Linux platforms, developers could not perform all the required checks. With the above technique, future versions of the Firebird server will also work, without the need to update the software.

IB 7 would not open FB 2 database and vice versa – they have different internal formats ODSwhile both now separate projects gave them the same version number. By using and further navigating this website you accept this. 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. After that point, the database becomes unavailable until backup and restore is performed to reset the transaction ID counter back to zero.

IB Surgeon Toggle navigation. This can lead to the impossibility of returning to the version back. Operating system user name.

Sign up using Email and Password. Note A legacy provider for databases with ODS 8 to This is also true for Firebird 2. That is not going to work, because Firebird 2.

Here, you see ODS number — this is encoded 11, with the high bit added since Firebird 2. Databases firebidr with bit and with bit builds of Firebird 1. Did you see this question?


As previously, Firebird will not open a database on little-endian that was created on big-endian, nor vice versa. For example, when you try to ovs with a 1. The three ID fields are just for information: If you only have command-line access you can use Firebird’s gstat command line tool located in bin directory. Later, it could be extended up to the 2 63 limit.

Firebird On-Disk-Structure (ODS) List – (HIME) Hall of Information & Materials from Estream

User and password here unnecessary, because gstat with —h option just read physical part of the database header page, number 0. Under these conditions, there will be no problems opening existing databases with the new Firebird sub-release.

Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms firebrid serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. For example, if we run gstat from InterBase 4 at database from Firebird 2, it will show Wrong ODS version, expected 8, encountered ? Changes to Client Address Reporting. Currently we have only one flag, for endianness.

There’s no way to know it upfront. It depends on various options that are known only when actually doing something. Wrong ODS version, expected 8, encountered ?

What is ODS version and how to retrieve it?

User and password here unnecessary, because gstat with —h option just read physical part of the database header page, number 0. Implementation ID is Deprecated. Wrong ODS version, expected 8, encountered 13? How to return to the previous version of Firebird or InterBase Sometimes, you may require performs a downgrade and return back from the new server. If it does, the ODS version must increase. 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 page.


If gstat will not understand read information, it will show corresponding message — what it expected, and what it found. ODS on-disk structure version is a number representing version of the database low-level data layout structure ODS.

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. If your program can ensure those requirements, then it can work. However, with Interbase 6.

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

We use cookies to make your experience of fiirebird websites better. Even if you tried to backup on the old server and restore at new, and it worked — never trust this. Back then it fierbird expected Interbase be kept opensource and re-use Firebird project code. For example, when Firebird 1. 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.

Not affiliated with Stack Overflow. Last versions of Firebird 3. Please e-mail us what needs to be changed. So, the minor upgrade of ODS makes incompatible databases within same major server version. But that assumes that the database is at minimum ODS Starting with FB 2.