Skip to main content

AI DDL Conversion

AI DDL Conversion transforms the current table definition into create-table statements for another database type. Use it as a draft when you plan cross-database migration, compatibility checks, or object duplication.

Supported Data Sources​

  • MySQL-family data sources (PolarDB-X is not supported)
  • Oracle
  • OceanBase Oracle
  • DaMeng
  • HANA
  • SQL Server

Before you begin​

  • Add the target data source to NineData.
  • Open the SQL Console for the data source that contains the table.
  • Use an account that can view the target table definition.
  • Confirm the destination database type before generating the converted DDL.

Procedure​

  1. Open the SQL Console for the target data source.
  2. In the object tree on the left, locate the target table.
  3. Right-click the table, then click Convert Schema.
  4. Select the target database type.
  5. Review the generated DDL and copy, save, or edit it for your target workflow.

Result​

NineData generates a DDL draft for the selected target database type. Before you use the statement in migration or production work, confirm data types, default values, indexes, constraints, partitioning, character sets, and other database-specific behavior.