Progress
Basic Database
Tools
Admin>Dump Data and Definitions
Choose this option to dump data and definitions.
NOTE: When a menu option prompts you for a filename only, you can specify a complete pathname.Table 10–2 describes the menu that appears when you choose this option. More detailed descriptions of the options follow the table.
Dump Data and Definitions
Data Definitions (.df file)
Choose this option to dump table definitions for an individual table or for all the tables in the database. The definition file contains the definitions of tables, which include fields, indexes, and all their characteristics. Progress alphabetically lists all the tables defined for your database. If you choose ALL, the definition file also contains the sequence and auto-connect record definitions.
After you select the tables you want to dump, Progress displays a default name for the file into which it dumps your data definitions (hidden tables are not dumped). This default file is the dump file name you specified when you created the table, or the database name with a .df extension. Progress truncates dump file names to eight characters.
Specify the filename or use the default value. Progress displays each object name as it writes its definition to the definition file. When it has dumped the data definitions, Progress displays a status message and prompts you to continue.
Dump Data and Definitions
Table Contents (.d file)
Choose this option to dump table contents. Progress alphabetically lists all the tables defined for your database. When you select only one table, Progress displays the Dump Data Contents dialog box for that table. If you select multiple tables, Progress displays the Dump Data Contents for Some Tables dialog box as shown in Figure 10–1.
Figure 10–1: Dump Data Contents for Some Tables Dialog Box
![]()
This dialog box contains the following user-interface elements:
Output Directory or Output File
Specifies the output directory if you choose to dump multiple tables. Specifies the output file if you choose to dump only one table. The default filename for each table is the dump filename you specified when you created the table, or table-name
.
d.Character Mapping
Specifies the type of character mapping.
Code-Page
Specifies the default code page (character set). A code page maps characters to numbers (code-points) and defines the character’s visual representation (glyph). Code pages usually represent a particular language’s alphabet, such as the ibm861 code page (Icelandic).
Progress displays each table name as it writes the table contents to the file’s contents file. Progress displays a status message and prompts you to continue.
Dump Data and Definitions
SQL Views
Choose this option to dump SQL view contents. Progress prompts you for the filename to which it writes the view. The default filename is
_view.d
. Specify the filename. Progress displays a status message and prompts you to continue.Dump Data and Definitions
User Table Contents
Choose this option to dump user information. Progress prompts you for the filename to which it writes the user table contents. The default filename is
_user.d
. Specify the filename. Progress displays a status message and prompts you to continue.Dump Data and Definitions
Auto-Connect Records Only
Choose this option to dump auto-connect records. Progress prompts you for the filename to which it writes the auto-connect records. The default filename is
_auto.df
. Specify the filename. Progress displays a status message and prompts you to continue.NOTE: The Data Dictionary does not have a separate option for loading auto-connect records. When you choose LoadData Definitions from the menu bar, Progress automatically loads all the table definitions, regardless of the table type.
Dump Data and Definitions
Collation Tables
Choose this option to dump collation tables, case conversion tables, and translation tables. Progress prompts you for the filename to which it writes the tables. The default filename is
_tran.df
. Specify the filename. Progress displays a status message and prompts you to continue.NOTE: The Data Dictionary does not have a separate option for loading the collation, case conversion, or translation tables. When you choose LoadData Definitions from the menu bar, Progress automatically loads all the table definitions, regardless of the table type.
Dump Data and Definitions
Sequences Definitions
Choose this option to dump sequence definitions. Progress prompts you for the name of the file to which it writes the sequence definitions. The default filename is
_seqdefs.df
. Specify the filename. Progress displays a status message and prompts you to continue.NOTE: The Data Dictionary does not have a separate option for loading sequence definitions. When you choose LoadData Definitions from the menu bar, Progress automatically loads all the table definitions, regardless of the table type.
Dump Data and Definitions
Sequences Current Values
Choose this option to dump sequence values. Progress prompts you for the filename to which it writes the sequence values. The default filename is
_seqvals.d
. Specify the filename. Progress displays a status message and prompts you to continue.NOTE: The Table Contents (.d file) option only dumps table contents. You must dump the sequence values separately.Dump Data and Definitions
Create Incremental .df File
Use this option to compare two Progress databases’ schemas and create a DF file that contains any differences. You can then use the new DF file to upgrade from a database to the current database.
NOTE: You need at least two databases connected to create an incremental DF file.When you choose this option, the Create Incremental Definitions File window shown in Figure 10–2 appears.
Figure 10–2: Create Incremental .df File Window
![]()
Progress lists all connected databases except the working database (which should be the database that has the newest version of the database schema). If you have more than two other databases connected, select the database that has the older version of the database schema. Progress then prompts you for the filename to which you want to write the differences. The default filename is
delta.df
. Progress displays the file, field, and index names as it compares the databases.You can then use this file to apply schema changes to an existing database.
NOTE: If you use this option to create a DF file in conjunction with an object file to update schema changes, you must load the DF file and recompile before you can run the new r-code. You must recompile because Progress reorders the indexes during the dump and load procedure.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |