Trajano Roberto wrote:

>
> To build our confidence, could you please assist us with the
> following:
> a) Can we copy EXACTLY all the store procedures developed for IB6.0
> to the latest stable version of FireBird?

No. If your procedures contain ambiguous field names in queries, FB will
reject them. With IB, you get unexpected results without noticing the
damage. Same if your client apps generate ambiguous queries.

> b) Can we copy EXACTLY all the database schema developed for IB6.0 to
> the latest stable version of FireBird?

No, if you have a column named FIRST or SKIP or CURRENT_USER or
CURRENT_ROLE. FB1.5 adds more keywords, following the SQL standard.

> c) Is there any FREE tool such as IBConsole for FireBird?
> If not, what is available out there?

IBOConsole, IBAccess, IBExpert personal edition, plus a cheap but powerful
DB WorkBench for FB.

> d) We heard that JayBird is the supported JDBC driver by the
> community. Is it stable as InterServer & InterClient?

Jaybird is probably better than those or Borland wouldn't have...

> e) If we would like to pay money to have guaranteed support, is there
> any private organisation in the market place providing these services?

Yes, IBPhoenix. Having Ann Harrison there, you don't risk to get bad tech
support.

> Thank you very much and waiting for a positive response.
> We would like to adopt FireBird now!

If you have questions that are more technical, please use the free
firebird-support at yahoogroups.com, please.

C.