copy dataset

Function Description

Copy one or more datasets to the target datasource. When datasets are selected, they can be added directly to the copy window for quick dataset copying.

It also supports the shortcut keys Ctrl+C and Ctrl+V. Specifically, select the dataset to be copied in the workspace manager and press Ctrl+C (copy), then select the target datasource and press Ctrl+V (paste), completing the dataset copying and pasting, which makes dataset migration between datasources more convenient and simple.

Function Entry

  • In the workspace manager, right-click on the dataset context menu -> Copy Dataset.
  • Toolbox -> Data Management -> Data Maintenance -> Copy Dataset.
  • Alternatively, in the workspace manager, drag the dataset to be copied to the target datasource node, a Copy Dataset dialog box will pop up. Click the OK button to copy the selected dataset to the specified datasource.
Tip:
  • You can use the Shift or Ctrl key to select multiple datasets for copying. The Copy Dataset in the toolbox can only copy a single dataset.

Parameter description

Each record in the Copy Dataset dialog corresponds to the copy information of a dataset to be copied. The meaning of each item is as follows:

  • Source dataset: Displays the type and name of the dataset being copied.
  • Source datasource: The datasource where the source dataset is located.
  • Target datasource: The Target datasource column specifies which datasource the copied dataset will be stored in. Each cell in this column has a drop-down button; click it to show a list of all open datasources in the current workspace. Select a datasource to store the copied dataset, or choose the new datasource option to create one.
  • Target dataset: The Target dataset column specifies the name of the new dataset after copying. The system provides a default name, which users can modify to their preferred name.
  • Encode type: The Encode type column specifies the encode type for the new dataset. Each cell has a drop-down button; click it to show a list of all encode types supported by the application. Dataset encode type refers to the compression method during storage. For details, see: Dataset compression encode type.
  • Character set: Sets the character format of the copied dataset. By default, it matches the source dataset. Users can select another character set to change it. For supported character sets, see: Character set list.
  • SmID unchanged: Preserves the SmID field attribute value unchanged from the source dataset.
Tip:
  • The Copy Dataset button is only activated when datasets are selected in the workspace manager.
  • When copying data from UDB/UDBX datasources to Oracle or SQL Server datasources, if text fields are present, the system automatically converts them to wide-character fields to ensure proper storage of multi-language characters.
  • When copying data to a PostGIS datasource, all field names are stored in lowercase.
  • Subtype in datasets is not supported during copying, meaning dataset subtype attributes will be lost.
  • Copying multiple datasets across datasources simultaneously is not supported.
  • Since vector plugins lack the SmUserID field, copying datasets from UDB/UDBX datasources to directly opened gpkg or gdb datasources will not automatically create this field.

Related Topics

New Dataset

Rename/Refresh Dataset

Save As/Delete/Close Dataset