Importing metadata from DDL scripts

Mac Lewandowski - Dataedo Team Mac Lewandowski 6th April, 2022

This feature is in beta version.

Available options

Dataedo offers multiple options for connecting with the Database and downloading metadata.

  1. One of the native connectors.
  2. ODBC connector.
  3. Import through DDL Script.
  4. Import through Interface Tables.

Schema

Concept of DDL script

Data Definition Language (DDL) is a subset of SQL. This language is used to describe database structure and relationships in a database. Using DDL script is a way of exchanging data with Dataedo Repository and any other external database.

DDL Flow

Did you know, that Dataedo also offers an option to export your database to DDL script?

How to use DDL script import?

You need to start with creating a script (dump) of your database structure.

Importing from DDL script

After you prepared the script file, you should use the new connector directly in Dataedo Desktop.

DDL Import

Script interpratation errors

Currently, there are no errors reported, during DDL script import. All objects which are not correctly recognized, are simply skipped during import.

If you notice on the summary, that your object is missing, you can fix the script manually, directly in the Dataedo import window.

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.