Let Flex2SQL Generate Scripts for the DBA¶

  1. Connect to the target server (File > Login).

  2. Optionally, set global migration preferences (Tools > Preferences).

  3. Open the DataFlex workspace or filelist (File > Open) and select the file(s) to be migrated.

  4. Select Tools > Generate Scripts > SQL Script for Creating Table.

This creates a script, <filename>.sql that the DBA can use to create the table(s).

  1. Select Tools > Generate .INT > .INT File from .DAT

This creates the .INT file(s), <filename>.int.

  1. Select Database > Create Text File for server-specific Loader.

  2. To save the data in a text file, select the Export Data & Control File option. Otherwise, only the controlling scripts and batch (.bat) file are generated. You can change the location of the text file and select whether you want a comma delimited file or a fixed format file.

  3. Display the Loader Options tab and choose settings to be saved in the control file.

  4. Click Generate or, if multiple files are selected, Generate All.

During the generation process, three files are created: <filename>.txt, loader.bat, <filename>.ctl. The <filename>.txt file contains the data in text format. Loader.bat is a batch file that contains the loader calls for each migrated file. The <filename>.ctl file contains control information used by the loader.

  1. The DBA runs the script to create the new table (filename.sql) and the loader.bat file to load the text data.

  2. Generate the script to analyze the loaded data (Tools > Post Loader Steps).

Note: Only available for PostgreSQL, MySQL, MariaDB and Oracle.

  1. The DBA runs the post loader script.