Subject Re: [firebird-support] Interbase 5.0 Database to Firebird 1.5
Author Lester Caine
Alan McDonald 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. 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!
>>I am out of ideas. Help.. Please :-)
> backup it up on the 5 server then restore it on the FB1.5 server but make
> sure you restore to Dialect 1 (not Dialect3)
> Alan

That is what he said he did - but the dialect should stay as 1.
It's some time since I cam through that full path, I've been with FB1
for some time now. I suspect that you may still have a problem with a
reserved word being used as a field name. I remember having to change a
couple of fields in IB5 to move it over to IB6/FB1, but perhaps someone
with a better memory can add some detail ;)

Lester Caine
L.S.Caine Electronic Services