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

www.ibphoenix.com has a list of replication tools
Alan