Subject Re: [firebird-support] Interbase 6.02 to Firebird 1.5 or above
Author Helen Borrie
At 01:19 AM 20/04/2005 +0000, you wrote:

>Delphi 5 enterprise
>IBX 5.04
>Interbase 6.02
>sorry by my poor english.
>I'd like to migrating my apps to Firebird, what must i do ?
>- I need to purchase IBOBJECTS to work Delphi - Firebird ?

"Need" is too strong a word. Anything that seems to work with that old
version of IBX should still work in the same way with Firebird
1.5. However, do make sure you are using the compatibility version of the
Firebird 1.5 client, both for development and when you deploy your client
programs. There is a program in the bin directory called instclient.exe
that you can use to generate this client. The documentation for it is in
the doc directory, named "README.Win32LibraryInstallation.txt".

This would, however, be a good time to be looking at alternatives to
IBX. It is a Borland product and its newer versions do not take account of
any new features or changes during Firebird's life. This is a deliberate
policy of Borland. There are plenty of alternatives available that *are*
Firebird-aware. IBO is the most sophisticated; FIBPlus is the closest in
architecture to IBX; there are several others around that use thinner
interfaces to the client library, including a custom driver for Borland's
DatabaseXpress (dbx) model.

It is most important to treat the release notes for both Firebird 1.0 and
Firebird 1.5 as additional manuals for Firebird. They represent four
years' worth of language changes and new reserved words. Some of your
queries that worked with IB 6 may be illegal in Firebird. This especially
affects joins, group by and order by.

>- Backup my GDB File in Interbase 6.02 and restore in Firebird 1.5 or

Definitely, you must do this. Another good thing to do, as soon as you
have recreated your database, would be to make a full metadata extract that
you can store in a safe place for reference.