Progress
Database Administration
Guide and Reference


Dumping Table Contents With a Data Tool

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

Follow these steps to dump table contents:

  1. Access the appropriate Data tool (Data Administration tool if you are using a graphical interface or the Data Dictionary if you are using a character interface).
  2. Make sure you are using the database (the source) where you want to dump the table data.
  3. Choose Admin Dump Data and Definitions Table Contents (.d files). The Data tool lists all the tables defined for the database alphabetically.
  4. Mark the table contents you want to copy. You can mark tables with asterisks (*), then use the Select Some and Deselect Some buttons to select or deselect groups of tables. If you are using a character interface, use F5 and F6.
  5. When you dump a single table, the Data tool displays a default name for the file that you can dump the table contents into (hidden tables are not dumped). This default file is always the dump name of the table definition file, with a .d extension.

    If you want to specify a file other than the default file, type the name in the Write output to file field. You can use filenames longer than eight characters for the data tables if your operating system allows it, but the Data tool requires a unique eight-character dump name (which you supply when you create the table).

    When you dump table contents for an entire database, the Data tool prompts you for a directory name to write the contents files to. If you do not specify a directory, the Data tool dumps the files into the current directory. The Data tool names each contents file with its corresponding table name.

  6. Accept the default or enter a different name.
  7. 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.
  8. The Data tool displays each table name as it writes the table contents to the table contents file. After dumping the table contents, the Data tool displays a status message and prompts you to continue.

  9. Choose OK to return to the Data Administration or Data Dictionary main window.
NOTE: You must dump the sequence values separately. See the "Dumping Sequence Values" section for information about dumping sequence values.


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