At 12:19 PM 05-06-01 +0100, you wrote:

>Hi all,
>
>I'm having problems with the Pdox2IB Metadata and Data Pump program.
>
>- I've created my database ok.
>- Then I login to my database for the pump program.
>- I open up one of my Paradox tables I want to migrate the data from.
>- I select the checkboxes for Do Datapump and Create Generator for Primary
>Key
>- I click Add to Script for Indices for Author
>- I click Add to Script for Script for Tables
>- I click Make Script, save the script, and execute it.
>- I then close this window.
>- I click Begin Datapump
>- I get a warning about having run the metadata pump script over my database
>(this is the ib_domain.sql script right? I've done that already)

I think you've bumped into a problem I tried to work around with regard to the script module, which is a plug-in. In short, you shouldn't close the script window. There are Clear, Load and Save buttons so there is no reason to close it. It's just that the script module hides its Close method and I didn't have time to make a descendant that the main form could control.

>- I get an error saying Table does not exist - File or directory does not
>exist - File: C:\Program Files\Borland\Delphi 3\Demos\Data\Author.DB
>
>I have my author.db table in a totally different place - why is it looking
>for it there? The path is displayed in the location box below where it says
>Paradox Table.

As the notes say, you need to define a BDE alias for the Paradox database. The selection routine relies on you selecting a valid alias so it knows the correct driver and database location to use. It is going to look wherever the last-selected alias points.

>If I try to do a table that requires a domain to be created in the Domains
>and Generators box then I get an error at the Execute script stage from the
>separate window that comes up. The confirm box comes up saying there is an
>ISC Error. Specified domain or source column does not exist.
>STATEMENT:
>TIB_DSQL: "IB_Script."
>
>It asks if I want to continue executing the script?
>What am I doing wrong?

As the notes say repeatedly, this app is highly dependent on doing things in the right order. I'd like to be able to say this is a robust, bomb-proof, stateless app but it certainly isn't. If you read the notes, you will see that you have to add the CREATE DOMAIN statements to the Generators and Domains window yourself.

It's quite a long time since I did this tool so I can't remember whether the program writes the "pre-defined" domains as its first step. Once you get the other bits right, would you mind checking that out and letting me know in private email?

Apart from these pre-defined domains (which you can change to suit yourself) there is absolutely no way the app could guess what domains you require, or even IF you require them. If anything, these domains are there as a guideline to covering the datatype differences between Dialects 1 and 3.

If you did add the statements, but added them to the Gen window *after* the application had created the main script, then it's too late. You can *still* edit the
script in the script window before you run it to create the metadata, though.

The app will save you a lot of typing and (to some degree) will assist you by choosing the datatypes for the conversion. It's not a magic wand. You need to get acquainted with what the tool is doing for you and what you need to do for yourself. Reading the notes (or re-reading them) should help.

Cheers,
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________