SDE Database Migration

Feature Description

Supports migrating data from SQL Server, Oracle, and PostgreSQL databases in SDE to SuperMap datasource.

Feature Entry

Data Migration tab->Data Migration->SDE Import;
Toolbox->Data Import->Import SDE.

Parameter Description

Database Name: The name of the database to be connected, which corresponds to the database in ArcMap.
Server Address: The instance name or IP address of the server in ArcMap, for example, if the ArcGIS instance is 192.168.17.96, enter the same name in the server field.

Note:

When the IP address of the Oracle server includes a port number, do not include the port number again here, or the connection will fail.
Username/Password: The username and password for the current database.
Version: The version name format is {owner}:{name}, obtained from [Geodatabase Connection Properties - Transaction Version]. For example, if the geodatabase connection properties show the name as DEFAULT and owner as dbo, then the version here should be written as dbo.DEFAULT.

License Verification: Select the ArcMap license type. Default represents the informal license type of ArcMap. Provide the Check button to see if the corresponding ArcGIS license information exists on the current machine.
Select Data: Check this option to select the data to be migrated in the pop-up data selection dialog; if unchecked, all data will be imported at once.
Read History: Available after selecting Select Data. If Select Data was checked when the database was previously imported, check Read History to directly read the previous query results, significantly improving data reading speed.
Datasource: The storage location of the data after import.
- Select Existing Datasource: The migrated data can be stored in an existing datasource within the current workspace.
- Create...: Supports creating a file-based or database-based datasource to store the migrated data.

Overwrite Datasets with the Same Name: Check this option, and if a dataset with the same name exists in the datasource, the newly imported dataset will overwrite the original dataset content.

Import SDE database to a file-based datasource. The SDE database contains image, text, mosaic datasets, and vector datasets. The migration effect is shown below: