SDE database migration

Function Description

Support the migration of data in SQL Server, Oracle and PostgreSQL databases in SDE to SuperMap Datasource.

Function entrance

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

Parameter Description

  • Database Name: the name of the Database to be connected, namely, the corresponding 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 Server Name.
    Caution:

    When the IP address connected to the Oracle server is appended with the port number, it is not necessary to add the port number when filling here, otherwise the connection will be wrong.

  • Username/Password: Username and password of the Current Data library.
  • Version: Version writing specification { Owner }: { Name }, obtained through Geodatabase Connection Properties-Transaction Version. For example, in the current geographic database connection attribute, the name is DEFAULT, the owner is dbo, and the version here is written as dbo. DEFAULT.

  • License verification: Select the Type of ArcMap. Default represents the non-Official License type of ArcMap. Provide the Check button to check whether the corresponding ArcGISLicense Information exists in the current machine.
  • Select Data: If this option is selected, the data to be migrated can be selected in the pop-up Select Data dialog box; if this option is not selected, all data will be imported at one time.
  • Datasource: The storage location of the imported data.
    • Select Existing data source: The migrated data supports the existing Datasource stored in the Current Workspace.
    • Create..: Support new file-type or database-type Datasource to store migrated data.
  • Overwrite Dataset of Same Name: Check this item. If Dataset of Same Name exists in Datasource, the new Import Dataset will overwrite the original Dataset content.

Import the SDE database to the Create File Datasource. The SDE database contains images, texts, Mosaic Dataset, Vector Dataset, etc. The migration effect is shown in the following figure:

Related content

Data Migration overview

Data Migration

Map document migration

Service Migration