--- In firebird-support@yahoogroups.com, "elleffeci" <elleffeci@y...>
wrote:

> Hi all,
> we are in the process of evaluating to migrate a working FB server
> from v1.0 to v1.5 . Since this server is a 'mission critical' one,

we

> must not fail.
> My concerns are:
>
> 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?

Technically no.

FB 1.5 is more strict with ambiguous syntax. In reality though if
your syntax that is doing something ambiguous, you have to cross your
fingers it is what you are after.

I will avoid question 2 because others will be able to give a more
accurate answer. Your upgrade procedure is correct, I am not sure
about the downgrade procedure.

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

The optimiser is smarter, so it really depends on how optimised it
already is. If you have already tweaked the query for maximum
performance on FB 1 then the performance benefits are not as big as
if you haven't done any performance testing during development.
(obviously)

FB 1.5 fixes a number of bugs and introduces some new features that
may be of interest. Read the release notes for the gory details.

Adam