I know there's a variety of different forums that I could post this
on, but since I use IBO, I figured this would be the best place to
start...

I have an application using the following platform:

Firebird 1.0
Dialect 1 database
Borland C++ Builder 4 Enterprise
IBObjects 4.3.Aa
Using a combination of TIB_ and TIBO components

I would like to bring my app into the 21st century, and upgrade as
much as possible. Preferrably:

Latest version of IBObjects
Latest stable version of Firebird that is supported by IBO
Latest database dialect that is supported by FB/IBO
Latest version of BCB that is supported by IBO
(I don't THINK I need Enterprise anymore; I used to need it because
the app used to use BDE w/ SQL Links)

My main overall question is: How major an undertaking is this going to be?

Specific questions:

1) What version numbers of the above should I be looking at?

2) How clean would the upgrade path be from BCB4 to the latest version
(that supports IBO)? How much of the process is automated? How much
code would I have to change manually? I'm not sure if this matters or
not, but this was originally a BCB1 app, and as such, the project file
is a .MAK file rather than a .BPR.

3) Is there much/any code rewrite or component replacement required to
jump up this far in IBO releases?

4) Will there me much code rewrite needed for the Firebird version and
dialect upgrade?

5) What about data migration? This is a commercial application, and
there are hundreds of installation, and they will need a clean/easy
upgrade process. Can the upgrade be done in one step, with the latest
version of Firebird? Put another way, can the latest Firebird read a
FB 1.0 dialect 1 database? If so, I'm fine with writing a data pump
application to move the data from one DB to another. Or, will they
have to export their data to an intermediate format with 1.0,
uninstall 1.0, install new version, then import it back in?

Anything else I might be missing?

Thanks in advance for any answers/advice you can offer.

-Joe