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 table contents (.d file).
The Dump Table 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 for 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 .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 Tables:
Dump contents from all shared and multi-tenant tables. By default, this option is selected.
All shared tables
Dump contents from all shared tables only.
Note: This option is available only for multi-tenant database connections.
All multi-tenant tables
Dump contents from all multi-tenant tables only.
Note: This option is available only for multi-tenant database connections.
Selected
Dump content either from one or many, shared and/or multi-tenant tables. This option appears both for multi-tenant and non-multi-tenant database connections. Selecting this option displays the Selected Tables section.
1 Databases that are not enabled for multi-tenancy do not have shared or multi-tenant tables.
In the Selected Tables section, do the following:
a. In the Table name field, enter a table name. You can specify a keyword, use the wildcard operator *, or a combination of both.
b. In the Database area field, specify a database area name which contains the tables you want to view. When you type a keyword in this field, the console lists database areas matching your keyword. You can select a database area name. For example, if you type Cu, the console lists the database areas Cust_Data and Cust_Index.
c. Select one of the following options:
Show shared and multi-tenant — to view tables that are both shared and multi-tenant. By default, this option is selected.
Show shared — to view only shared tables.
Show multi-tenant — to view only multi-tenant tables.
d. Select the Show hidden check box to view any hidden tables from the database.
e. Click Apply Filter. Based on your search criteria, the Selected Tables section lists the table names and displays the following columns:
Column name
Description
Schema
Displays whether the schema associated with the database table is public or user-defined. The default value is PUB which indicates that the default public schema is assigned to the OpenEdge database.
Table name
Displays the name of tables in an ascending alphabetical order.
Area
Displays the area in the database in which the table resides.
Multi-Tenant
Displays true for multi-tenant tables and false for shared tables.
Description
Displays details associated with the table name. This column is optional. To view this column, click any of the column's drop-down and select Columns > Description check box.
14. Select Tenants based on whether you access the database as a regular or a super user.
Note: In the case of multi-tenant database connections, you must provide either regular or super user credentials to dump or load tenant data. Refer to Managing users in a multi-tenant database. If you do not provide any credentials for database authentication, you can only dump or load default database tables.
For regular tenant user credentials, Tenants displays a preselected radio button for the regular tenant and you can only dump contents from the table within that specific regular tenant.
For super-tenant user credentials, Tenants displays two options for you to select and dump contents from the tables included within these tenants.
Choose All to select all regular tenants.
Choose Selected to filter one or more tenants. Upon choosing Selected, the console displays the Selected Tenants section. You can enter either a keyword, the wildcard operator *, or a combination of the two in the Tenant name field. Click Apply filter to view the Tenant name and the Description in the respective columns. Use the check boxes to select or clear any of the tenant entries.
Optionally, you can click the columns drop-down to select options such Type, Id, External Id, and Data Enabled to display the respective tenant properties. Similarly, you can clear the check box to remove any of the columns from the Selected Tenants view.
The option for displaying tenants is not available for non-multi-tenant databases.
15. Click Dump. A confirmation dialog appears for table data dump displaying the number of shared and multi-tenant tables that will be dumped.
16. Do one of the following:
Click Commit to dump contents of the selected tables. You can view 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 tables, 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 table in the dump directory you specify (in this case, the work directory C:\OpenEdge\WRK).
Select > > .