paradox to mysql

Hi nabil_zakkak,

You may want to check out the information in the Database Solutions section of the web site where we describe -- in general terms -- which of the DataTools products to use for your particular type of data conversion.

You might also read a section about creating table indexes and primary keys in the help topic entitled "Creating and Using SQL Connections" in the documentation for the Data UpLoader. In that help topic, there is a section entitled "Creating SQL Table Indexes and Primary Keys". Here's how to find that documentation:

1. After launching the Data UpLoader, click on the Help button (question mark icon) at the right end of the button bar.
2. When the Help window opens, if you cannot see the Contents, Index, Search, and Favorite tabs, click the Show icon.
3. Click on the Search tab.
4. Enter "ConstraintDDL" in the search box and click on the List Topics button.

The first help topic you will see listed should be "Creating and Using SQL Connections".

5. Double-click on this topic to open it in the right side of the Help window.
6. Scroll down in that help topic and locate the "Creating SQL Table Indexes and Primary Keys" section.

The information will describe how to enter SQL statements in the Target Property called "ConstraintDDL" that you will see after connecting to your target database on the Target Connection tab in the Data UpLoader.

And lastly, if you will provide some additional details about your Paradox to MySQL migration, we are happy to offer some suggestions for how the DataTools can help.

- Jo