Subject Re: [firebird-support] Interbase 5.0 Database to Firebird 1.5
Author Helen Borrie
At 12:39 AM 9/01/2005 -0500, you wrote:

>Hi folks,
>I have an Interbase 5.0 database (and Interbase 5.0 installed on a
>server). I need to move that DB to a Firebird 1.5 DB. I tried to
>backup on the 5.0 server (transportable format) and restore on the FB
>server. Everything seems OK, but when I try to access the data, I get a
>data conversion error.

OK, this is because a number of data types changed between ODS 9 (which is
the IB 5.x on-disk structure) and ODS 10 (which was IB 6 and Firebird 1).
Firebird's gbak -c will restore it as a Dialect 1 database and you must
ensure that you connect from a client that is also set Dialect 1. Isql
will detect the correcti dialect automatically; some other tools may
simply default to dialect 3.

You don't say what you mean by "access the data". A now invalid query
might be the cause of a data conversion error, too. Give more precise
details about what you're doing when you encounter the data conversion
error and someone will be able to steer you.

>I then tried to copy the 5.0 DB file (after
>stopping the DB service) to the Firebird machine. Same problem. I then
>tried to backup and restore the DB on the Firebird server. No Joy!

Actually, provided you have your client set to dialect 1, you should be
able to read an IB 5 database. But backing up an IB 5 database using Fb
1.5's gbak won't work or, if it does, it will result in a potentially
corrupt database.