Progress
Database Administration
Guide and Reference


Dumping 4GL Database Definitions

Use the Data Dictionary or Data Administration tool to dump database definitions. There are two ways to dump the database definitions:

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. Table 13–1 shows the definitions that are dumped in each case.

Table 13–1: 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. For instructions, see the "Dumping Sequence Definitions" and "Dumping Auto-connect Records" sections later in this chapter.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095