The solve this case, click on the “Advanced” button on the Table Mapping page.

Then switch to the “Booleans” tab page and add a new string-to-boolean mapping pair by clicking on the green button. Finally, enter your Strings and close the dialog.

1.) dbCOPY starts with a task-oriented, simple interface that offers access to the most heavily used features. In this case we select “Export“. But you could also use features like Update or Append as soon as you have created the table structure (or in case that you would like to transfer data regularly between Paradox and another DBS).

2.) In the next step we configure our source and target connection.

3.) The Table Mapping Dialog allows us to specify which tables should be exported. You could also rename the table or append a timestamp to every table created (useful for regular backups).

4.) If necessary you could also configure a specific field mapping. In our example we would like to fill the field ‘City’ with the static value ‘New York’ and replace the strings ‘Mr’ and ‘Mrs’ with 0 respectively 1.

5.) To start the process just click ‘Start’ and dbCOPY automatically creates the table structure and copies the data. In our example it just takes 765ms to build the structure and transfer more than 900 records.

6.) You can immediately check the results with the integrated database viewer.

We hope that this walk-through explains to you how easy it is to migrate data from Paradox to another database with dbCOPY. In case that you have any questions please do not hesitate to contact us!

If you have any other feature requests or questions please do not hesitate to contact us!

Diese neue Version wird neben Bugfixes auch mehrere neue Features enthalten. U.a. ist ein Tab-Table Viewer und eine Filterfunktion im Viewer vorgesehen.

Therefor go into the dbCOPY program folder and call dbCOPYCC.exe like follows:

Syntax:
dbCOPYCC -file:path|-profile:path [-quiet] [-verbose] [-log:file]

Options:
-file:path      Executes an exported copy profile.
-file:path      Executes an exported copy profile.
-quiet          Prints only application failures.
-verbose      Prints detailed information.
-log:file        Saves the copy log file at the specified location. A standard log file will be created by default.

Examples:
Executing an exported copy profile:
dbCOPYCC -file:”C:\profiles\copy.dbp”

Executing a saved profile:
dbCOPYCC -profile:”shop\backup”

You can download the latest version of dbCOPY in your personal login area.

Please have a look at our walk-through which explains in-depth how to export data from Paradox to mySQL.