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.
|Published (Last):||5 June 2009|
|PDF File Size:||14.36 Mb|
|ePub File Size:||6.44 Mb|
|Price:||Free* [*Free Regsitration Required]|
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. For Named Pipes a. Sometimes server may upgrade old ODS to some newer one, without notification.
All Firebird and InterBase On-Disk-Structure (ODS) versions
If your program can ensure those requirements, then it can work. Existing databases with ODS If you made the backup before server upgrade, there will be no problems to return back. Sign up using Facebook. What is ODS version and how to retrieve it? For example, if you open a database with ODS 8. 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.
Check the engine version – http: As previously, Firebird will not open a database on little-endian that was created on big-endian, nor vice versa. ODS on-disk structure is a number representing version of the database physical layout structure. If oxs desire so, the changes will be credited to your name. Per-table performance counters have been added to all of the monitoring tables. If you haven’t used any new features of server X version firebifd InterBase or Firebirdso you may return to X-1 following these steps: There’s no way to know it upfront.
ODS on-disk structure version is a number representing version of the database low-level data layout structure ODS. IB Surgeon Toggle navigation.
Since I have not found anything useful, I ended up creating a small function, which uses isql to create a bare bone database and extracts the ODS version with direct file access. It will show something like. For example, if we run gstat from InterBase 4 at database from Firebird 2, it will show Wrong ODS version, expected 8, encountered ? 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.
What is ODS version and how to retrieve it?
To firebrid 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. If it does, the ODS version must increase. When a new feature is added to Firebird it might or might not require the structure of ifrebird pages or system tables database metadata to change.
Historically, transaction ID space was limited to 2 31 transactions, counted from the time the database was created. Not affiliated with Stack Overflow.
User and password here unnecessary, because gstat with —h option just read physical part of the database header page, number 0. For information about authentication mapping, see Mapping of Users to Objects in the Security chapter. They were carefully checked to verify that, for them, there is no actual difference between ODS 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.
Even if you tried to backup on the old server and restore at new, and it worked — never trust this. It depends on various options that are known only when actually doing something. Map the engine version to native ODS version using Firebird documentation or knowledge base articles like http: Later, it could be extended up to the 2 63 limit. User and password here unnecessary, because gstat with —h option just read fidebird part of the database header page, number 0.