Primary Key and Recnum Conversion Rules
You need to decide whether converted tables should have primary keys and whether Recnum Tables should be converted to Standard Tables.
Primary Keys
We recommend allowing the wizard to detect and assign primary keys to tables being converted. Primary Keys are a standard feature of SQL database tables.
Recnum to Standard Tables
We recommend using Standard Tables when converting to an SQL database.
If you are not using the embedded database (and since you are converting to an SQL database, you will not be), you should only use this option when the table will be used in a legacy DataFlex application that requires Recnum support in each table.
In all other cases, you will simply define a unique RowID using the primary key columns of your new table.
This option sets the DF_File_Recnum_Table attribute.