3.7.4 Migrating Database Connections

You can migrate your connections in Spatial Studio between on-premises and cloud database environments.

It is possible that you may want to migrate data from your on-premises database to an Autonomous Database instance or the other way around. In such scenarios, you can also migrate the Spatial Studio connection related to the data to the new target data source. Thus, Spatial Studio allows you to continue working with the datasets that were created using the earlier connection properties, without rendering them invalid.

You can perform the following steps to migrate a database connection.

1. Navigate to the Connections page.
2. Right-click on the required connection Name.
   The context menu for the database connection appears as shown:

   Figure 3-36 Migrate Option for a Database Connection

   
   Description of "Figure 3-36 Migrate Option for a Database Connection"
3. Click Migrate.
   Migrate Database Connection is displayed as shown:

   Figure 3-37 Migrate Database Connection

   
   Description of "Figure 3-37 Migrate Database Connection"

   Note that in the preceding image, the target environment for migration may vary depending on the current source of the database connection. You can perform the following steps to configure the target environment that applies to you:

   • Migrating from On-Premises Database to Oracle Autonomous Database:
     1. Click Next and provide the Upload Wallet details.
     2. Click OK and provide the database connection details.
   • Migrating from Oracle Autonomous Database to On-Premises Database:
     1. Click Next and provide the database connection details.
     2. Click OK.
   The connection gets updated to the new data source.