How can I generate SQL from ERD

I have been looking around but couldn’t find a solution. Is there a way I can generate SQL script for all the DDL of all the entities I defined in the ERD. Or am I missing a step that I have to convert it first into ORM diagram before generating the SQL scripts.

The Code generate option doesn’t show SQL option for the language.

I have Visual Paradigm Suite 3.0

Hello ulateef,

Thank you for your post. Please follow the steps below to generate DLL:

  1. Select Tools > ORM > Generate Database… from the main menu
  2. Check Generate DDL
  3. Set the output path (a directory)
  4. Click OK to generate

Best regards,
Jick


generate-ddl.png