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 > .

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

   Parameter	Description
   	Enter 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.
   	The source data source of the schema transformation.
   	The target data source of the schema transformation.
   	Select the naming rule for objects after schema transformation. : Regardless of the naming rule on the source end, all naming rules on the target end are lowercase. : Maintain the naming rule from the source end. : Regardless of the naming rule on the source end, all naming rules on the target end are uppercase.

4. On the tab, select the content to be copied from the list, click > to add it to the right list, then click .

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

   • Click to view the execution status of the schema transformation task.
   • Click to return to the task list page under .

View Schema Transformation Results and Execute in the Target Database

1. Log in to the NineData console.

2. In the left navigation pane, click > .

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

   

   Number	Function	Description
   1	Task Status	The current status of the schema transformation task.
   2	Download SQL|Delete Task	Click the Download button to download all SQL files converted in the current task. You can directly execute these files in the target database. Click > Delete to delete the current schema transformation task.
   3	Object Details	Click on the tabs of each object to view the details of the schema transformation.
   4	View DDL	View the DDL before and after the transformation, and you can perform copy commands.
   5	Execute	You can directly execute the DDL after the transformation in the target database. Select , then click .
   6	More	View naming rules for schema transformation tasks and copy object information.