Database Menu¶

The Database menu lets you select conversion settings, perform the data migration, create a text file for high-speed migration, or browse DataFlex or migrated tables. Commands on the Database menu require that a file(s) is selected in the filelist. Database menu commands are also available from the Filelist popup menu.

  • Convert Database (Toolbar Item i_ConvertDatabase): Shows the Convert Dat to Table dialog. Database conversion is the core Flex2SQL operation. This allows you convert your tables.

  • Browse Data (Toolbar Item i_BrowseData): Shows the Browse Data dialog for the selected table.

  • Drop Table: After confirming the action, it drops the selected table or tables from the SQL database and, applicable, reverts the entry in the filelist to the corresponding DataFlex .DAT file. If a DataFlex file is selected, this entry will be disabled.

  • Drop View: Drops the selected view from the SQL database. This option is used if a filelist entry was created based on a view. If a DataFlex file is selected, this entry will be disabled.

  • Analyze Storage Requirements: Option is disabled for all other database targets EXCEPT Oracle. This allows you to analyze your Oracle storage requirements before migration.

  • Create Text File for Loader: Option is disabled for MSSQL database targets. This allows you to generate a text file from one or more DataFlex files to be used in high speed migration.

  • Analyze After Load Execution: Option is disabled for MSSQL database targets. This option is used to recompute index statistics and reset sequences (Oracle, MySql, MariaDB, and PostgreSQL only). Please note. after each loader execution, you must run the Analyze After Load Execution option for each migrated file. THIS IS VERY IMPORTANT. This option analyzes the system and adjusts the RECNUM values to run properly with DataFlex. If this option is not executed finds will behave erratically.

  • Adjust Sequence Definition: Option is disabled for all other database targets EXCEPT Oracle. This option resets the Oracle sequence definition to start from the next available value in the sequence. This is required if your data was migrated with the Preserve Recnum Value option. Running this option, updates the Oracle sequence definition to start at 1 plus the highest RECNUM value in the DataFlex table.

  • Enable Trigger to Handle Inverse Key: Enables a trigger to automatically manage inverse keys whenever an insert, update, or deletion of a record takes place. Inverse key fields are additional fields created during data migration to handle indexes with descending index segments. These additional fields allow the driver to scan a set of data in descending order without issuing an order by clause. Inverse keys are also used to support upper case indexes.

  • Disable Trigger to Handle Inverse Key: Disables the trigger to handle inverse keys.

  • Select A Database (Toolbar Item i_SelectADatabase): Allows you select the target database.

  • Change Table Handler: For MySQL/MariaDB only Changes the MySQL/MariaDB table format.

  • Copy Data from .DAT File to Table: Copies data from a DataFlex file to an existing table. Typically, this option is used to copy data to an empty table created using Flex2SQL.

  • Copy Data from Table to .DAT file: Copies data into a DataFlex file from a table on the server. This is normally done on a blank data file.

  • Erase a DataFlex file: Uses the DataFlex zerofile command on the DataFlex file to remove all records from the file.

  • Erase a Table: Deletes all records from the selected table.