On 29 Jul 2005 at 6:28, elleffeci wrote:

>1) SQL compatibility: can we be sure that *ALL* SQL queries in our
>application, currently running on FB1.0, will be OK with FB1.5 without
>touching the SQL?

No. SQL parser in FB1.5 is more strictive.

>2) backward migration: should any problem arise after installing and
>using FB1.5, how can we 'revert' back to v1.0?

Yes.

>3) can we hope in a performance gain by migrating to 1.5?

Yes.

>About point 2), we did some internal tests by
>- gbak'ing our DB with gbak 1.0,
>- restoring the DB with v1.5 gbak on a machine with FB1.5
>- playing around with the new installation.
>
>the questions now are:
>a) is this the correct migration procedure?

Yes.

>b) is it possible to revert the DB back to v1.0 by gbak'ing it with
>1.5 gbak and restoring it with v.1.0 gbak, or is there another
>procedure?

You must use gbak from FB1.0 to downgrade. I.e. backup with 1.0
gbak and restore with 1.0 gbak.

<shameless advertise>
If your database is so 'mission critical' why not to use
replication? Install FB1.5 on another server, set up replication,
move part of connects to new server, wait, move some more clients,
wait again. If something is wrong - you can return to FB1.0 server
without data and time losses.
</shameless advertise>
--
SY, Dimitry Sibiryakov.