Chapter 27. Export and Import

  1. Home
  2. Docs
  3. Chapter 27. Export and Import
  4. 5. Command-line Interface
  5. Reversing DDL with command

Reversing DDL with command

Download PDF

To reverse DDL through the command line:

  1. Browse the scripts folder under the Visual Paradigm installation directory. For Mac users, you can find the scripts folder in the Visual Paradigm package by right-clicking on it and then selecting Show Package Contents. Then look in Contents\Resources\app\scripts for the scripts folder.
  2. Start the command prompt.
  3. Execute the script by supplying the required parameters. For example:
    ReverseDDL -project C:\Demo\Demo.vpp -path C:\Demo\DDL\mydb.ddl -database Oracle

    Parameter Description Example
    -project Project path C:\Demo\Demo.vpp
    -path The path of the DDL to be reversed C:\Demo\DDL\mydb.ddl
    -database DATABASE_TYPE:
    “MySQL 5.0.5 or higher”
    “MySQL 5.0.4 or lower”
    “Oracle”
    “MS SQL”
    “Sybase ASE”
    “PostgreSQL”
    “Firebird”
    Oracle
    -encoding [optional] The encoding of the .sql or .ddl file.