Subject Re: [ib-support] Migrating from IB 6.01 to FB 1.2
Author Helen Borrie
At 05:39 PM 20/03/2003 -0800, you wrote:
>It is time for me to byte the bullet and migrate from IB to FB.
>Correct me if I'm wrong but all I should have to do is:
>1. Uninstall IB
>2. Install FB
>(FreeUDFLib.dll still is compatible)
>3. backup IB database and restore after FB is installed.

Errm - step 3 should be step 1. ;-)

>1. Uninstall IB client.
>2. Install FB client.
>Are there any gotchyas I should be aware of?

Ambiguous queries involving multiple tables will be your main gotcha. FB
will reject multi-table queries (joins, self-joins, subqueries, unions)
that don't have fully qualified column names. (It's fine for the
qualifiers to be table aliases).

For example, some ambiguous system queries hard-coded into the IBConsole
program don't work in Firebird.

Another is "mixed syntax" inner joins. IB allows these (with unpredictable
output outcomes); FB will block them. That is, mixing the SQL-89
comma-list syntax for table names with the SQL-92 JOIN...ON syntax. Use of
both (as in "one" or "the other" is fully supported.

New language syntax introduced into IB 6.5 and later is not supported.

Firebird has a number of new reserved words, as well - see the ReleaseNotes.

Can't think of anything else at the moment...