Skip to main content

Schema Transformation

NineData schema transformation supports the conversion of table structures between heterogeneous data sources. After the transformation is completed, you can perform operations to build tables in the target data source.

Prerequisites

  • The data sources participating in the schema transformation have been added to NineData. For instructions on how to add data sources, see Adding Data Sources.
  • The type of the source data source is Oracle, with one of the versions being 23ai, 21c, 19c, 18c, 12c, or 11g.
  • The type of the target data source is PostgreSQL, with one of the versions being 15, 14, 13, 12, 11, or 10.

Procedure

  1. Log in to the NineData console.

  2. In the left navigation pane, click Replication > Schema Conversion.

  3. Click on Create Conversion on the page, configure according to the table below, and click Next.

    Parameter
    Description
    NameEnter the name of the schema transformation task for easy retrieval and management. Please use meaningful names as much as possible. Supports up to 64 characters.
    SourceThe source data source of the schema transformation.
    TargetThe target data source of the schema transformation.
    Target Object NameSelect the naming rule for objects after schema transformation.
    • Convert all to Lowercase: Regardless of the naming rule on the source end, all naming rules on the target end are lowercase.
    • Consistent with Source: Maintain the naming rule from the source end.
    • Convert all to Uppercase: Regardless of the naming rule on the source end, all naming rules on the target end are uppercase.
  4. On the Select Objects tab, select the content to be copied from the Source Object list, click > to add it to the right Target Object list, then click Launch.

  5. On the Launch tab, when prompted with Launch Successfully, the schema transformation begins. At this point, you can:

    • Click View Details to view the execution status of the schema transformation task.
    • Click Back to list to return to the task list page under Schema Conversion.

View Schema Transformation Results and Execute in the Target Database

  1. Log in to the NineData console.

  2. In the left navigation pane, click Replication > Schema Conversion.

  3. On the Schema Conversion page, click on the Task ID of the target task, and the page will be as follows.

    conversion_result

    Number
    Function
    Description
    1Task StatusThe current status of the schema transformation task.
    2Download SQL|Delete TaskClick the Download button to download all SQL files converted in the current task. You can directly execute these files in the target database.
    Click more-4269757> Delete to delete the current schema transformation task.
    3Object DetailsClick on the tabs of each object to view the details of the schema transformation.
    4View DDLView the DDL before and after the transformation, and you can perform copy commands.
    5ExecuteYou can directly execute the DDL after the transformation in the target database. Select Target DB, then click OK.
    6MoreView naming rules for schema transformation tasks and copy object information.
Get support
WeCom