SQL Conversion Wizard: Select Table Connection Options
Schema
Enter a schema (optional) if your database connection requires one.
Delete Original Table After Conversion
Checking this option will delete a successfully converted table from the source database. For example, if converting from the embedded database, this would delete all embedded database files (*.dat, *.vld, *.hdr, *.k).
Trim varchar values
Checking this option trims string data when the destination type is varchar. This is useful when converting embedded DataFlex tables to SQL databases that use varchar columns and compare space-padded and trimmed values differently.QL databases. The embedded database stores data in OEM format. We recommend onverting Checking this option trims string data when the destination type is varchar. This is useful when converting embedded DataFlex tables to SQL databases that use varchar columns and compare space-padded and trimmed values differently.
Convert Definition Only
This option allows you to create a converted table on the target database without copying any data to it.
Keep New Table Even If Some Records Cannot Be Copied
This option allows you to create a converted table on the target database and permits the wizard to complete the conversion even if some data cannot be copied from the source table to the target table.