Progress
Basic Database
Tools


Dumping Table Contents

When you dump table data, Progress creates a contents file that contains data for each table you specify. This file has a .d extension. Progress uses the contents file to load data into your database. Progress creates a separate contents file for every table you dump.

For information about performing a binary dump and load, see the "Binary Dump and Load" section later in this chapter.

To dump table contents, follow these steps:

  1. Access the Data Dictionary tool.
  2. Make sure you are using the database (the source) from which you want to dump the table data.
  3. Choose Admin Dump Data and Definitions Table Contents (.d files) from the menu bar. Progress alphabetically lists all the tables defined for your database (hidden tables do not display).
  4. Select the table names whose contents you want to dump. Use the Select Some and Deselect Some buttons to select or deselect groups of tables.
  5. Press GO.
  6. If you selected a single table, Progress displays a default name for the file that you can dump your table contents into. This default file name is always the dump name of the table definition file, with a .d extension. If you want to specify a file name other than the default file, type the name in the Output File field.

    If you selected more than one table, Progress prompts you for a directory name to write the contents files. If you do not specify a directory, Progress creates the files in the current directory. Progress names each contents file with the table’s corresponding dump name.

  7. Accept the default or enter a different name.
  8. If you want to use character mapping, enter the character mapping, then choose OK. See the Progress Internationalization Guide for information about character mapping, PROTERMCAP, and national language support.
  9. Specify the code page or accept the default.
  10. Progress displays each table name as it writes the table contents to the table contents file. After dumping the table contents, Progress displays a status message. Choose OK to return to the Data Dictionary window.

  11. Choose OK to dump the data contents file(s) and return to the Data Dictionary main window.
NOTE: You must dump your sequence values separately.


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