Copying a table

Copying a table copies all items from one table to another. The table can be copied using a right-click menu option or by dragging-and-dropping a table to a new destination.

Note:

If the table being copied is a Dictionary, the D-pointers are not copied.
Copying by using the menu option is more efficient when copying files on the same server.
When using the drag-and-drop method, if the table being copied already exists in the destination table, the copy operation will fail.

Procedure

Right-click the table to copy from the Domain Explorer and select the Copy option.
The D3 Table Copy dialog box displays. Note that the characteristics of the table being copied are displayed in the Source section of the dialog box.

Complete these fields:

Value	Description
Database	Database name for the destination table. By default, the destination table is assumed to be on the same database as the source.
Dictionary	File Dictionary.
Data Level	Data Level.
Level	Either Master Dictionary, Dictionary, or Data Level. By default, the destination level is assumed to be identical to the source level. As appropriate, selecting one of the buttons disables some other fields.
Overwrite Existing Records	When checked, records with the same record-IDs will be overwritten. If not checked, conflicting records will not be overwritten.

Click Copy.
The copy operation is performed and the number of records copied displays.

If both the source and destination table are on the same server, the copy operation takes place entirely on the remote server. If they are not on the same server, the copy operation is performed by the client, which reads the items from one server and copies them to the other.

Tip: To copy using drag-and-drop, select the Dictionary or Data Level table node to copy from the Domain Explorer, press and hold the CTRL key and then drag-and-drop the selected node to the destination Data Level or Dictionary node.