Preferences¶
How to access
Toolbar item
User this dialog to set global preferences for using Flex2SQL Classic Migration Utility.
There are 7 Tabs:
Preferences - General Tab: This tab allows you to set options that affect all migrations including the terminating character(s) for SQL scripts, file casing preferences, filelist position for the new tables, and how errors are handled.
Login Tab: This tab controls whether SQL specific information is included in one or more .INT files.
DFPATH Tab: This tab controls which DFPath Flex2SQL uses during data migration.
Reports Tab: This tab controls the migration report feature.
Field Mappings: Allows you to set global field mapping between DataFlex data types and the data types of the target RDBMS.
Preferences - General Tab¶
This tab allows you to set options that affect all migrations including the terminating character(s) for SQL scripts, file casing preferences, filelist position for the new tables, and how errors are handled.
Overwrite Existing File: If this option is checked, a table with the same name is overwritten during migration. By default, the option is turned off, and you are prompted before a table is overwritten.
Erase Table before Data Migration from DAT: If this option is checked, the contents of the target table are erased before the contents of the DataFlex data file are copied. By default, this option is turned off.
Save current settings for the future: If this option is checked, preferences are saved for future use.
Disable Status Panel: If this option is checked, the progress panel is disabled during migration.
SQL Script Generator¶
SQL Scripts for creating tables, indexes, sequences, and other database objects can be terminated with just a line feed (LF) or with a carriage return (CR) and LF. The SQL generator creates an ASCII file. By selecting the appropriate end of line character, the file can be viewed in the UNIX or Windows environment. For UNIX, select the LF character as a terminator. For Windows, select the CR and LF characters.
Terminate each with LF: Generate text file in the Unix/Linux format. This should be used if you are going to run your scripts from a UNIX or Linux platform.
Terminate each with CR+LF: Generate text file in Windows format. This should be used if you will run your scripts on a database server running on a Windows platform.
File Casing¶
You can control whether existing file casing is used or upper or lower case conversion takes place. This option is used in conjunction with MySQL, MariaDB and PostgreSQL conversions to determine if the objects (tables, columns, indexes, etc) are created with upper or lower case letters.
Upper: Selecting the Upper` radio button forces all text to be converted to uppercase.
Lower: Selecting the Lower radio button forces all text to be converted to lowercase.
Keep Casing: Selecting the Keep Casing radio button maintains all text case as it is currently stored in each DataFlex file.
Error Handling During Data Migration¶
Set options to handle errors during migration.
Cancel Migration after N errors: This option terminates the migration process if too many errors are encountered. This is typically due to bad data and you must correct all data related errors before proceeding with the migration.
Show All Error Messages: This option displays a popup dialog box with error messages as they are encountered during migration.
Language Support¶
If your computer is configured with multiple languages, you can choose the display language from this pulldown list.