Generate Scripts

How to access

  • Main Menu | Tools | Generate Scripts

Note

The tools listed in this menu should ONLY be used with tables that have been migrated. If you try and use it on a DataFlex file that has not been migrated, you will some variation of the error “File Not Found”.

Flex2SQL allows you to generate SQL scripts. The following can be created:

  • SQL Script for Creating Tables: Shows the Create Script SQL dialog. This allows you to generate scripts to create tables, indexes, primary key constraints, and sequence objects (where applicable).

  • SQL Script for Post Loader steps: Shows the SQL Script for Post Loader steps dialog. Generates scripts for post loader steps. Not enabled for MS SQL.

  • SQL Script for Adjusting Sequence Definitions: Only enabled for PostgreSQL and Oracle Shows the SQL Script for Adjusting Sequence Definitions dialog. Generates scripts to initialize auto increment columns (in PostgreSQL) or sequences (in Oracle) to be the highest number in the table plus one.

  • SQL Script for Enabling Inverse Key Triggers: Shows the SQL Script for enabling recnum and inverse key triggers dialog. Generates scripts for enabling inverse key triggers.

  • SQL Script for Disabling Inverse Key Triggers: Shows the SQL Script for disabling recnum and inverse key triggers dialog. Generates scripts for disabling inverse key triggers.

  • SQL Script for Dropping objects: Shows the SQL Script for Dropping Objects dialog. Generates scripts for dropping indexes, tables, and other objects such as sequence definition on Oracle or a table in any SQL database engine.

Note

  • All of these menu items are disabled if using an Evaluation License. Only valid licenses can access them.

  • When generating multiple scripts, note that script files with the same name will be overwritten NOT appended.