Generation of Interbase table scripts from Paradox tables

[StevenK]

I'm looking for an application whereby I can indicate a Paradox table and then generate a script for the equivalent table structure within an Interbase table. I need to maintain the primary and secondary keys.
Does anyone know of (or has developed) an application that achieves this ?
Alternatively any advice of how I might go about this would be apreciated.
Thanks in advance.
Steve

 

[Svanhooft]

Hi,

Simple you can use DataDesktop. The only thing you have todo is to make 2 aliasses, 1 for the paradox table and 1 for the destination table in Interbase.
With the DataDesktop you can now copy the paradox table to the interbase table. You can choose to copy the table including the data or only the structure.

succes,

Steph

 

[StevenK]

Is this the Borland DataPump tool ?
We're familiar with that through converting Paradox data to SQL Server but have found that it does not do a complete job. It will generate the Primary Key for the table but will omit the secondary indexes which I also am required to re-produce.
Is there something I'm missing ?
Steve

 

[Svanhooft]

hi,

it's not the datapump. You have also dbd32.exe. with a normal installation of delphi it's in :
c:\program files\borland\database desktop

Steph

 

[svanels]

You should try to use the datapump Utility, however I do not have experience with secondary indexes.
In all cases, paradox and interbase are from Borland so I think there will be less problems then paradox --> sql server, or paradox --> oracle.

At least the relation ships and validity checks are transported.

Regards S. van Els
SAvanEls@cq-link.sr