Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Dumping and Loading : Dumping ABL database definitions
 

Dumping ABL database definitions

Use the Data Dictionary or Data Administration tool to dump ABL (Advanced Business Language) database definitions. There are two ways to dump the database definitions:
*Dump the entire database, including all its tables and fields
*Dump individual tables, sequences, or auto-connect records
Whenever you run the dump utility to dump table definitions, the Data Dictionary or Data Administration tool creates a data definitions (.df) file that contains definitions of tables, fields, indexes, sequences, and auto-connect records, and all their characteristics. However, depending on whether you choose to dump all tables or only selected tables when you dump the definitions, the Data Dictionary or Data Administration tool might or might not write all definitions to the .df file.
The table below shows the definitions that are dumped in each case.
Table 50. Definitions dumped to the definition file
Definitions
All tables
Selected tables
Tables, fields, and indexes
Yes
Yes
Sequence definitions
Yes
No
Auto-connect records
Yes
No
Collation
No
No
_User
No
No
If you dump individual tables, you must also dump the sequence definitions and auto-connect records separately. See Dumpingsequence definitions and Dumpingauto-connect records for instructions.
* Dumping ABL database or table definitions
* Definition file format
* Multi-tenant keywords
* Creating an incremental ABL data definitions file
* Dumping sequence definitions
* Dumping auto-connect records