I am trying to extract data from a Firebird 2.5 SQL database for migration. The data has been built up over a long period through software that has the Firebird 2.5 database embeded - and the software company is not being helpful in allowing access to our data in an easily migratable form ...
By changing the security2.fdb file I can access the database through isql
using the administrator username SYSDBA
and can list the tables in the database, but any further access to individual tables always throws the message: "there is no table XXXX in this database"
Here is an example of the Windows command prompt:
SQL> show tables;
....
....
Customer
....
SQL> show table customer;
There is no table CUSTOMER in this database
I suspect that access to individual tables is controlled, but can't work out how to regain access, if this is possible at all.
See Question&Answers more detail:os