Subject Re: Migrating from FB 1.0 to FB 1.5
Author Adam
--- In, Fabrício Fadel Kammer
<ffkammer@c...> wrote:
> Hi all,
> I've a software that works with Firebird 1.0 and I'm needing to
> migrating to 1.5, because I need of some functions available only in FB
> 1.5 version. But I've a lot of customers that using my software and I'm
> afraid to update my software with a new version that use Firebird 1.5
> and my tecnicals don't update the Firebird Server and Client on the
> machines of my customers... What will happen???

Obviously any new feature of 1.5 will give an error if you try and use
it against the 1.0 engine. It is possible that your error message
codes may be different and you may get some odd error messages if you
upgrade the client but not the server.

> How can I prevent
> this??? And what's is the best form to do the migration from FB 1.0 to
> 1.5???

Firstly, you must ensure you do not use ambiguous queries that 1.0
accepts but 1.5 will return errors. For example

select id
from table1 t1
join table 2 t2 on ( = t2.table1id)

will return (something) in FB 1.0 but will be rejected by FB 1.5 as
ambiguous if ID is a field in both tables.

In other words, FB 1.5 may not accept some poorly written queries (as
seen above).

As for your second concern, it is really a non issue. When upgrading
your software, instruct the technical staff (in writing!) that part of
the upgrade procedure is to remove 1.0 and install 1.5, you may need
to write step by step instructions. As far as upgrading the client,
well all you need to do is put the new fbclient / gds32 dll (depending
on your connection components) in with your new binaries and presto.

I doubt the sky will fall in if you mismatch versions, just some
annoyed customers who get some error dialog box saying "undefined
function coalesce" or something like that.