Converting to the Embedded Database
Database Builder provides a tool for converting tables into the embedded database from any other supported database type. This tool will convert the table structures from the current workspace's database into an embedded database and then move all of the data.
To convert tables from the current workspace's database into an embedded database, select Convert to Embedded from the Database menu. This activates the Table Selection Dialog.
Select the tables that you wish to convert, then click the Convert button. This activates the Convert to Embedded Database dialog. Enter the following selections:
Keep Identity
Select this option if you want to keep the record identity field of the table as part of its structure once it is converted to DataFlex.
If the table was converted to SQL using an older version of the SQL drivers, a DFRECNUM column was created in the table being converted. When converting that kind of table back to DataFlex, you have the option of keeping that column as part of your DataFlex table structure.
Delete Original After Conversion
Select this option if you would like to delete the original tables after successful conversion. If any errors occur during conversion, the original tables will not be removed regardless of the selection you make here.
Convert Definition Only
Check this option if you want to create the tables in DataFlex but do not want to have your data copied over to the table.
Run Unattended
Select this option if you prefer to have a log file (DATAFLEX.LOG) containing the results of the conversion created. Should errors occur during conversion, they will be written to the log file. The file will be placed in the current working directory (i.e., the data directory of the current workspace). If there is already a file with this name in that directory, the log information will be appended to the existing file.
If the option is not checked, error messages will pop up if errors occur during conversion.
Transaction Type
Select a transaction type parameter for each table to be converted. Refer to Transaction Type for more information.
Compression
Select the data compression type to be used for each table. Refer to Compression for more information.