Subject RE: [firebird-support] Interbase 5.0 Database to Firebird 1.5
Author Alan McDonald
> >>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 :-)
> >>
> >>Marv
> >
> > 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
> -----------------------------
he didn't mention anything about the dialect