Advanced Database & Application Migration (ADAM) allows you to use Data Transmission Service (DTS) to migrate data. This topic describes how to exclude schemas, migrate data, and include schemas.


  1. Exclude schemas.
    1. Click the Excluded Schemas tab on the Excluded Schemas tab, and then click Start.
      Before you migrate data, you must remove TRIGGER and FOREIGN KEY from the destination database. Excluded Schemas
    2. In the message that appears, click OK.
      click ok
    3. Click the Schema Details tab to view the details of the schema objects that you want to exclude.
      Schema Details
  2. Migrate data.
    1. Click the Data Migration tab, and then click Create Migration Project.
    2. In the Purchase DTS Instance dialog box, enter the required information and click Buy Now.
      • Project Name: the name of the migration project.
      • Region of Data Migration Channel: the region where the destination instance resides.
      • Specification of Data Migration Channel: the specification of the data migration instance. For more information, see Specifications of data migration instances.
    3. Click Configure Migration Task. In the Create Migration Project dialog box, set the parameters of the source Oracle database and the destination database. Add the CIDR blocks of DTS servers to the whitelist of the source Oracle database.
      Note ADAM allows you to migrate Oracle databases that have public IP addresses or Oracle databases that are connected over Database Gateway.
    4. Click Test Connectivity to perform a test. After the test succeeds, click the Select Table tab. Select Full Data or Incremental Data Migration based on your business requirements. Click Select and select the tables that you want to migrate.
      If you select tables, the following message appears: Do you want to select all records?
      • Yes: Select all the tables in the table list.
      • No: Select only the tables on the current page.

      By default, the tables are sorted by data volume. You can skip the migration of the tables that have a large amount of data, such as logs. We recommend that you remove these tables after you click Yes.

    5. Click Create. After the configuration is complete, the migration task automatically starts. However, errors may occur if a large amount of data is migrated at one time. Therefore, ADAM migrates data in batches.
    6. Click View Details to go to the DTS console. On the Overview page, you can check the details of the migration task. If the data migration instance cannot meet your requirements for data volume, you can click Upgrade in the Actions column to upgrade the specification of the data migration instance.
      View Details
  3. Include schemas.
    1. Click Start on the Included Schemas tab.
      Create a trigger and foreign key after the data migration is complete. Start
    2. In the message that appears, click OK.
    3. Click the Schema Details tab to view the details of the schema objects.
      Schema Details