Subject Re: [firebird-support] Migration from Interbase 6.0 to Firebird 1.5
Author Svein Erling Tysvær
Firebird 1.5 has fixed a lot of errors that were in InterBase 6.0. InterBase didn't always complain about ambiguous queries, but tried to guess what it should do. Firebird tries to identify such code and returns an error upon prepare. I think there may also be a few new reserved words, and Arno made a few changes to the optimizer.

I didn't think InterBase 6.0 accepted any other extention than .gdb, but if you've managed to do that, it is just my memory that is fooling me to believe that code change appeared later than it actually did.

Any version of Firebird (at least since 0.9.4) is superior to InterBase 6.0. But you ought to test a bit, e.g. check that statements still prepare OK. I cannot remember any cases where the IB 6 optimizer does a better job than Fb 1.5, but they may well exist - forcing you to change your query a bit.


chemait wrote:
> Hi,
> I have an application in Delphi 5 Enterprise whith Interbase 6.0.
> In W2k it works fine, but in W Xp, it start running very slowly.
> I have change the extension gdb for another but is it still very slow.
> Now I'm trying to comver my DB to Firebird 1.5. I have make a backup
> with Interbase 6 and a restore with firebird. It seems to work very fast.
> My question is: It is fully compatible? Have I to do anything else?
> Thanks a lot.
> Chema.
> mailto:administrador@...

[Non-text portions of this message have been removed]