When you dump group contents using the Database Administration console, the .d file is created in a sub-directory of the work directory you specify. The default work directory is C:\OpenEdge\WRK.
To dump group contents:
1. In the management console menu, do one of the following:
Select Database Administration > Dump > Group Contents (.d files).
Select Database Administration > Go to Database Administration. The Database Administration page appears.
Filter or search for, and select the required database connection. The database connection home page appears.
In the Data Administration section, click Dump group contents (.d file).
The Dump Group Contents page for the selected database connection appears.
2. In the Database connection field, enter a database connection name that contains the database into which you want to load the table contents. By default, the last used database connection name appears in the Database connection field.
You can select another database connection by entering a database name in the Database connection field.
Note: If you type the name of the database connection, follow the format used by OpenEdge Management/OpenEdge Explorer to define a connection: AdminServer-name.database-name. A database server must be running for you to connect to the database.
You can also click the Search icon to choose a database for which you are creating the tenant from the Connection Selection dialog.
The Connection Selection dialog displays the connections details in a grid. You can perform the following:
Filter the connections in the grid by Connection name, AdminServer, and/or Category.
Select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the connections to appear in the grid.
Note: When you select a database connection name, the Database connection field displays the selected database connection name. Most of the other fields get auto-populated with the default values, based on the selected database connection name.
3. In the Dump root directory field, specify a file path of the directory in which you want to store the contents (.d) file. By default, this field displays the work directory C:\OpenEdge\WRK.
4. Select Include LOB to enable exporting of large database objects, such as images. By default, this check box is selected.
5. In the LOB sub-directory field, specify a sub-directory name in which you want to store the large database objects. By default, this field displays lobs and this sub-directory is contained in the default work directory C:\OpenEdge\WRK.
6. In the Code page field, specify a value for code page. By default, this field displays ISO8859-1. For more information on code pages, see OpenEdge Development: Internationalizing Applications.
7. In the Group sub-directory field, specify a sub-directory name in which you want to store group contents. By default, this field displays groups and this sub-directory is contained in the default work directory C:\OpenEdge\WRK.
8. In the Character mapping field, specify MAP or NO-MAP for character mapping. For more information about character mapping, PROTERMCAP, and national language support, see OpenEdge Development: Internationalizing Applications.
9. Select the Overwrite existing .d files check box, to overwrite the existing dump (.d) file.
10. Select the Do not dump secured tables check box, if you do not want to dump secured tables.
11. Select the Do not dump group tables check box, if you do no want to dump group tables.
12. Select the Do not validate code page check box, to skip validating the value entered in the Code page field.
13. Select one of the following options for Groups:
Dump contents from all groups. By default, this option is selected.
Selected
Dump content either from one or many groups. Selecting this option displays the Selected Groups section.
1 Databases that are not enabled for multi-tenancy do not have groups.
In the Selected Groups section, do the following:
a. In the Group name field, enter a group name. You can specify a keyword, use the wildcard operator *, or a combination of both.
b. Click Apply Filter. Based on your search criteria, the Selected Groups section lists the group names and displays the following columns:
Column name
Description
Group name
Displays the name of groups in an ascending alphabetical order.
Schema
Displays whether the schema associated with the database group is public or user-defined. The default value is PUB which indicates that the default public schema is assigned to the OpenEdge database.
Table
Displays the table in the database with which the group is associated.
Is allocated
Displays true if space is allocated for objects in the group.
Description
Displays details associated with the group name. This column is optional. To view this column, click any of the column's drop-down and select Columns > Description check box.
14. Click Dump. A confirmation dialog appears for group data dump displaying the number of groups that will be dumped.
15. Do one of the following:
Click Commit to dump contents of the selected groups. You can view the status of such a task in the Database Administration Tasks page by selecting Database Administration > View > Database Tasks.
Click Commit & Monitor to dump contents of the selected groups, and view the task page. This page lists the details of the dump activity performed.
Click Cancel to exit the dumping process.
When this operation is successful, a contents (.d) file is created for each group in the groups sub-directory of the dump directory you specify (in this case, the work directory C:\OpenEdge\WRK).
Select > > .