Subject Re: [IBDI] Conversion tool
Author Carl J. Mosca
Paul,

> There are a variety of tools, some freeware, some shareware, some good and
> some bad... if you have something releatively sophisticated, that can
handle
> multiple databases etc we would be very interested in working with you to
> make it freely available.... Can you give me some more information on what
> its capabilities are ?

It's not really much at this point. It allows the user to select a BDE
alias (or directory name) and then presents a list of tables. An Interbase
database can then be selected and a (new) table name entered if desired.
The "convert" scans the existing tables field names for spaces and Interbase
keywords. Spaces are replaced with underscores and keywords can be quoted
(if desired) or modified. Index(es) are also examined.

SQL is then generated, presented, and executed to create the table and
indexes. The populate functionality has been added and removed depending on
my particular needs at the time.

It's a pretty basic tool and I have modified it as I have moved Paradox and
xBase tables to various higher end databases (especially InterBase). I have
not taken the time to make in parameter driven but have often thought about
that as I encounter new databases, field types, and keywords. I know
there's a "DataPump" tool that is/was part of Delphi Enterprise but I don't
own a copy of last time I did work for a client who did, I found problems
with it.

I thought if I mentioned it, someone might mention something everyone else
is using. If there's not anything then maybe a free tool is needed as all
figure out what a great reliable database InterBase is.

Maybe a wish list could be presented and we'll see what happens.

Thnaks for responding,
Carl