At 04:11 AM 19-06-02 +0000, you wrote:

>I have a Paradox app that has 56 tables which I want to convert to
>Firebird.
>
>Are there any tools available that can help automate this process?
>
>I tried the db_to_IB application from the files area. It worked well
>for the table strucutre, except that it didn't bring the indexes
>over :(
>
>I need a tool that can transfer the structure and all indexes.

You could try my pdox2ib tool from
http://www.ibobjects.com/ibocontributed.html. It actually builds a DDL
script which includes indexes and generators (for any autoinc keys you have
in your *.db tables).

It's *not* a magic bullet tool, though. It does offer conversion
recommendations but you do need to understand Interbase and, in general,
how client/server databases differ from file-based databases like Paradox.

IOW, it will reconstruct your existing indexes but they are probably not
going to be of value to you in a C/s database...for example, forming key
relationships by way of hierarchical primary indexes (classic Paradox
style) is not the way SQL c/s databases do it, and it is worse than useless
- a complete killer, in fact.

Also understand that converting structure does not transfer metadata. The
pdox2ib tool has a datapump feature that you can invoke once you have a
workable IB database with conversion rules the tool understands, but you
need to be aware of those fundamental differences. You can pick up a paper
on moving to client/server (also by me) from the TechInfo page of the IB
Objects site.

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________