Exporting to DDL

Applies to: Dataedo 24.x (current) versions, Article available also for: 10.x, 23.x

Export to DDL

Since Dataedo 10.1 you can export your data structure to data description language (DDL). In other words, you will be able to export the database to a set of statements like CREATE and ALTER.

Starting the export

Start the Export from the main menu, and then choose database, and Script type.

DDL Start

Configuring the scope

Based on what you choose on the step, a set of checkboxes will be set by default.

  • For the "New database" option - all objects will be selected.
  • For the "Update existing" option - only manual objects will be selected.

You can alter the selection as you wish and proceed.


Setting export options

The last step before generation is a place where you can configure the export script.


In the next steps script will be generated.



Why my foreign key was not exported?

To correctly export a foreign key, you need to select all tables, which this key requires.

Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.