Subject Re: [ib-support] IB upgrade/switch to FB
Author Artur Anjos
Hi KK,

> 1./
> Is FB enough stable ?
> I not use stored proc/trigger in database, only query-s needed, etc.
> Anybody have experience about this theme ?

Are you suggesting that we are using a non-stable database in our products?
:-)

> 2./
> I know the FB use the old ODSs, but it is don't change this old format
> ?
> So if I want to use IB6.0 again, the IB recognize this database ?
> (I not use backup - only transportable format).
Yes. Just don't use any of Firebird new features.

> (I want to re-switch to IB, when the FB crashed, or I found a big bug.)
Is this a joke? :-)
Please take a look at Firebird Release Notes. This will teach you about IB
Bugs. You don't need to find them, someone else already did it.

> 3./
> Is FB "sensitive" to to many prepares ?
> (In the IB6.0 I heard about the to many prepares crashed the server.
> Or it is a legend only ?)
Legend that I never heard about.

> 4./
> If I switch to FB, I must change the client's gds32.dll to FB gds32.
> dll ?
> Or is FB gds32 compatible IB gds32 ?
Change to the Fb one. Use the Fb client with IB 6, if you want to. It's not
a good idea to do the oposite.

> Thanx for any help !
> KK
You will notice than more then 95% of the people on this list is using
Firebird. Must of us are using in production the release candidates of
Firebird 1, instead of Interbase (no time to switch all the clients). The
reasons are simple, and once again, they are documented in the Release
Notes.

The only problem that you could have is related with Ambigous Querys (IB
allows them, Fb will give you an error message).

Artur