Let Flex2SQL Perform the Tasks¶

  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 Convert Database, choose Create Table Only and then click Convert or, if multiple files are selected, Convert All.

This creates an empty SQL table(s) and the .INT file(s), <filename>.int.

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

Note: The displayed dialog box is server-specific. Examples that follow are for an Oracle database.

  1. 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.

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

  3. 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 loader.bat file to load the text data.

  2. Run the Analyze After Loader option for each migrated file (Database > Analyze after server-specific Loader).

  • See Also: High-Speed Script Based Migration - Let Flex2SQL Generate Scripts for the DBA