Tools Menu¶

The Tools menu allows you to create scripts, generate .INT, .DEF, or .FD files, and set migration preferences.

• Generate Scripts: Flex2SQL allows you to generate SQL scripts to perform certain tasks on the server. You can either create all the tables using the convert database option or you can generate SQL scripts to create blank tables.

• Generate .INT: This allows you to generate an INT file from either a .DAT file or another .INT file.

• Generate .DEF: Select this menu item when you want to save the structure of your SQL table in a DEF file. The DEF file is a text file with a specific format defined by DataFlex to describe the data files.

• Generate .FD: Select this menu item when you have an SQL table and you want to access it through a DataFlex application. The .FD file is required by the DataFlex compiler to map fields.

• Preferences: Select this menu item to set global preferences for using Flex2SQL Utility Classic.