--- In firebird-support@yahoogroups.com, "Dmitry Sibiryakov" <SD@t...>
wrote:

> 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.

Oh, gosh: do you mean we could get some parse errors?!

>
> >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.

OK, I'll give it a try! Thank you!

>
> <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>

That could be very good: I sketched the index of 'The Firebird Book'
but I did not find the term 'replication'. Any pointer to sources that
can explain what you mean by replication and how to perform it will be
greatly appreciated, Dmitry!

Thank you again,
Luca.