Compare DDL

Step 1: Input and Compare DDL

In this step, you'll input two DDLs (Data Definition Language) for comparison. This helps identify changes in database schema.

  1. First, select the database type and version.
  2. Enter the local (new) DDL in the left input box.
  3. Enter the original (old) DDL in the right input box.
  4. When finished, click the "Start Compare" button.
Select Operations

Step 2: Review Differences and Select Operations

In this step, you can review the differences between the two DDLs and select the change operations you want to apply.

  • Carefully examine the displayed changes.
  • Select the change operations you wish to apply.
  • Once confirmed, click the "Generate SQL" button.
SQL Result

Step 3: Review Generated SQL and Complete

In this final step, you can review the SQL change statements generated based on your selected operations.

  • Carefully check if the generated SQL statements meet your expectations.
  • If modifications are needed, click the "Back" button to return to the previous step.
  • If everything looks correct, click "Append to Origin DDL" to apply the changes to the original DDL.