Description

The Import from DDL option can be used to import a data model as a single data definition language (DDL) or multiple into a Project. A DDL File can be read to create multiple Domains within a Project.

Note: A Single Table DDL can be used to create a single Domain by pasting a single table DDL. To learn more about this method, please view this help article.


In This Article


How to create multiple Domains from a DDL File

  • Select a Test Data Project and navigate to the Domains Pane in the Projects Dashboard. The Domains Pane will be visible when a project has been selected.



  • Open the New Domain drop-down menu.



  • Click on the Import from DDL option in the menu.



  • Select the Import Multiple Domains from DDL option and click the Next button.




  • Select a Vendor from the drop-down menu (mysql for this example).

  • Click on Choose File to browse to and select the DDL file.

  • Click the Save button once finished.




  • Wait for the DDL to be imported. The DDL file is now placed in a queue.

  • The user who initiated the import will receive an email when the import has started and been completed. Once the completion email is received, the Domains have been imported into the selected Project.


DDL Audit

After the import, the user can view a DDL audit to see if any errors occurred. The DDL import audit can be accessed from the Project Versions Pane.
  • Click on the GenRocket Table Schema (GTS) Audit Details option.



  • In the DDL Audit Dialog, select a DDL import to audit and click the Next button. 

  • If this is the first time a DDL has been imported, only one will be visible.



  • The DDL Audit will appear as shown below:


  • NOTE: The Import from DDL option does not support some keywords. Make sure to remove any of the following keywords before importing the DDL:
    • DEFAULT 'N'::bpchar
    • FOR SBCS DATA
    • WITHOUT TIME ZONE
    • ON UPDATE CURRENT_TIMESTAMP(N)
    • GENERATED BY DEFAULT AS IDENTITY START WITH N
    • FORMAT 'K' BETWEEN M AND N

Training Video

The following video can be viewed to learn more about creating multiple Domains from a DDL as well: