I'm analyzing a Home windows application that utilizes a database of unknown type. The database includes several files with file extensions, .i, .iz, .b2, .p and .bi. Can there be an API you can use to see the look, tables and items in this database? The ambition would be to migrate the information to some MySQL atmosphere.

Make use of a hex editor and find out db inside in binary mode. You might get the opportunity to begin to see the file enter in the couple of beginning bytes. Then alter the extension properly and open it up.

Possibly the Unix [cde] utility (obtainable in Cygwin) can identify them.

From FileExt.com:

File Extension BI

File type: Binary File

Primary association: Binary File

Other programs connected with file type BI:

  • Progress (Database Before Image File) by Progress Software Corporation
  • Quick Fundamental or Visual Fundamental for DOS (Include File) by Microsoft Corporation Much like C's .H but can be used only in Microsoft's DOS Fundamental dialects. Means "Fundamental Include". This association is considered Text.

Anyway...

Odds are it's not really a relational database system this program uses most ad-hoc, single-use databases produced for use within one program are what exactly are known as "flat-file databases", meaning "records" possess a set size and therefore are utilized through an approach to file-ing through it as being you'd an ordinary file. For example, should you set the record size to twenty, then your first record could be in the byte range -19, the 2nd could be at 20-39, etc.

Should you could in some way derive exactly what the record size this specific program uses, you can split the file in to the component records as binary data. Decoding that data into significant information would most likely be considered a hassle, though.