Hi Jonathan,

> >>I don't really feel like switching my database server to FB now at the
> >>very end of a long developpement project...
> >
> >Your option is non-sense to me. Look at Firebird 1.0 as an improved IB

6.01

> >OS, with a lot of bug fixes. Read the Release Notes and you know what

I'm

> >talking about.
> >
> >
> Do you mean to say that it's entirely compatible? Can I take an IB 6.0

No - it's compatible, execpt for a few keywords and the ambigious queries.

> database, and simply run it with FB 1.0, without a backup/restore?
> Do you really think I can count on it reacting the same way, without
> wasting days trying to get my application to run properly again?

Always do a backup-restore when switching versions.

> >In my oppinion, your long development project will be much more safer

with

> >Firebird, even if you have to test it a little bit more (the only problem

I

> >see will be ambigous querys, that Firebird will catch as an error.

Another

> >improvement to your project - you are not aware of ambigous querys with

IB

> >6).
> >
> What are ambigous queries? Could you give me an example please?

Table A:
ID
NAME

Table B:
ID
CATEGORY

select id, name, category
from tablea left outer join tableb on (tablea.id = tableb.id)

In the SELECT clause, InterBase will give you the "ID" column without
problems -
but from what table? Firebird, instead, will raise an error.

> >But the question remains: How can you trust a dead open-source project as

a

> >SQL server for a project that took you so long to develop? :-)
> >
> >
> Well, if I were to have any problems with IB 6.0, I wouldn't hesitate to
> upgrade to FB 1.0. But as long as I have no problem ... why create
> potential problems?
> After all, once a critical project is finished, and working, it takes a
> pretty strong incentive to upgade the database server! If it's working,
> don't break it! However, in this case, it might be worth considering, as
> it's either that, or forget Zebedee...
>

Test a little, test all your queries - and you should be fine.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com