[colug-432] Firebird DB

[Rick Hornsby]

I have what I believe is a Firebird database file - SAMDB.fdb.

I don’t know anything about the internal database structure, but I need to get the data out of it.  I’ve been having a hard time getting any of the supposed tools to work to read the file.  Most of them won’t run in Linux (ELF compatibility errors?) or won’t compile properly.  It’s weird.

The closest I’ve gotten is using Windows to run fbexport -Si -D c:\path\to\SAMDB.fdb. That complains a username and password aren’t set - which seem to be related somehow to the Firebird server.

I have access to CentOS, Ubuntu, OS X, and Windows 7.  Anyone familiar with this file format and can help give me some straight forward instructions? The output format isn’t super important, but I guess there are multiple tables so structure is important, and I’ll probably end up importing the data into a mySQL database.

thanks!