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.

To copy by dragging-and-dropping a table:

1. Select the Dictionary or Data Level table node to copy from the Domain Explorer.

2. Press and hold the CTRL key and then drag-and-drop the selected node to the destination Data Level or Dictionary node.

   The selected table is copied to the destination table.

To copy using the menu option:

1. 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.

   

2. Complete these fields:

   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.

3. 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.

See Also

Tables

Creating a Table

Listing the Content of a Table

Counting a Table

Deleting a Table

Creating a New Data Level for a Table

Clearing a Table

Renaming a Table

Moving a Table

Table Correlatives