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.

Table 10–2: Dump Data and Definitions Menu
Dump Data and Definitions

Data Definitions (.df file)...

Dumps the table definitions.

Table Contents (.d file)...

Dumps table contents.

SQL Views...

Dumps view contents.

User Table Contents...

Dumps user information.

Auto-Connect Records only...

Dumps auto-connect records.

Collation Tables...

Dumps collation or translation tables.

Sequences Definitions...

Dumps sequence definitions.

Sequences Current Values...

Dumps sequence values.

Create incremental .df File...

Compares two Progress database schemas and creates a DF file that contains any differences.

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 Load Data 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 Load Data 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 Load Data 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