数据库是在哪个版本的Interbase或Firebird上创建的?

问题描述

我有一个扩展名为.ib的文件.我猜它是 Interbase 或 Firebird 文件，但是我很难确定到底是哪个文件.此外，还不清楚使用Interbase(或Firebird)的哪个版本创建文件.

I have a file with an extension .ib. I am guessing it is either an Interbase or a Firebird file, but I am having trouble working out exactly which. Furthermore, it isn't clear exactly which version of Interbase (or Firebird) was used to create the file.

到目前为止我发现的东西:

What I have found so far:

我尝试了各种不同的软件来读取此文件(FlameRobin，Firebird的isql.exe以及Interbase的最新版本)，并且错误消息告诉我ODS(磁盘结构")是版本9.已经很老了，可以追溯到Firebird从Interbase分叉的时间.

I have tried various different software to read this file (FlameRobin, Firebird's isql.exe and also the latest version of Interbase) and the error messages I get tell me the ODS ("On Disk Structure") is version 9. Which is quite old, and dates to around the time that Firebird was forked from Interbase.

我已经设法连接到数据库并使用Firebird对其进行查询，但是由于出现一些错误，我不得不相信它实际上是一个Interbase数据库(如果需要，我可以进一步解释)

I have managed to connect to the database and query it using Firebird, but some errors I'm getting lead me to believe it is actually an Interbase database (I can explain further if required)

是否有一种可靠的方法来确定准确我正在处理哪种数据库?即它是Interbase还是Firebird文件，如果是，它是用哪个版本编写的?

Is there a fool proof way of determining exactly what sort of database I'm dealing with? i.e. is it an Interbase or Firebird file and if so which version was it written with?

gstat.exe -h的输出使用Firebird 2.5运行:

The output of gstat.exe -h run using Firebird 2.5:

Database header page information:
    Flags           0
    Checksum        12345
    Generation      7558
    Page size       4096
    ODS version     9.1
    Oldest transaction  7506
    Oldest active       7544
    Oldest snapshot     7544
    Next transaction    7549
    Bumped transaction  1
    Sequence number     0
    Next attachment ID  5
    Implementation ID   16
    Shadow count        0
    Page buffers        0
    Next header page    0
    Database dialect    1
    Attributes      force write

    Variable header data:
    Sweep interval:     20000
    *END*

总结:

• 获取Firebird的副本
• 从bin目录运行gstat.exe -h
• 从输出中获取ODS版本
• 在此处的表中查找

• Get a copy of Firebird
• Run gstat.exe -h from the bin directory
• Get the ODS version from the output
• Look it up in the table here

推荐答案

1. 关于ODS及其获取方式.
2. Firebird，Interbase版本和相应的ODS .它是俄语的，但是您可以阅读该表.它具有列-版本，主要ODS版本，支持的ODS版本.

1. About ODS and how to get it.
2. Firebird, Interbase versions and corresponding ODS. It is on Russian, but the table you can read. It has columns - Version, Main ODS version, Supported ODS versions.

这篇关于数据库是在哪个版本的Interbase或Firebird上创建的?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！