SQL utilities are programs that facilitate the administration of your OpenEdge database. Utilities such as SQLDUMP, SQLLOAD, and SQLSCHEMA enable you to perform a variety of tasks including:

  • Creating a new version of a database.
  • Economizing disk space.
  • Migrating a database to a different operating system.
  • Updating database schema.

SQLDUMP utility

The SQLDUMP utility is a command-line utility that dumps application data from SQL tables into one or more files. You can load the data from the files into another database with the SQLLOAD utility. The SQLDUMP utility does not dump data from ABL tables. The utility is available only for tables that were created with SQL.

For more information, see SQLDUMP utility.

SQLLOAD utility

The SQLLOAD utility loads user data from a formatted file into an SQL database. Typically, the source file for the load is created by executing the SQLDUMP utility. The SQLLOAD utility can process a source file created by another application or utility, if the format of the file conforms to SQLLOAD requirements.

For more information, see SQLLOAD utility.

SQLSCHEMA utility

The SQLSCHEMA utility is a command‑line utility that writes SQL database schema components to an output file selectively. You can capture table definitions including table constraints, views, stored procedures including related privileges, and triggers.

For more information, see SQLSCHEMA utility.