Details

    • Type: How To
    • Status: Published
    • Affects Version/s: Exasol 6.1.0, EXASOL 6.0.8, Exasol 6.2.x
    • Fix Version/s: None
    • Component/s: EXASolution
    • Labels:
      None
    • Solution:
      Hide

      Background

      EXAplus provides the functionality to create the DDL for the database (right-click on "Schemas" in Databasbrowser -> CREATE DDL).
      The attached file provides a Lua script to do the task almost similar without EXAplus.

      Prerequisites

      There are parameters to influence the output style. Documentation on the parameters and some known restrictions can be found at the beginning of the script. Version 2 adds support for new features in version 6.1. Please see the header of the script for more information on what is supported and the current limitations.

      Copy Database script

      For a complete metadata backup solution, please see SOL-613.

      Example call:

      -- parameters: add_user_structure, add_rights, store_in_table
      execute script create_DDL(true, true, false);
      
      Show
      Background EXAplus provides the functionality to create the DDL for the database (right-click on "Schemas" in Databasbrowser -> CREATE DDL). The attached file provides a Lua script to do the task almost similar without EXAplus. Prerequisites There are parameters to influence the output style. Documentation on the parameters and some known restrictions can be found at the beginning of the script. Version 2 adds support for new features in version 6.1. Please see the header of the script for more information on what is supported and the current limitations. Copy Database script For a complete metadata backup solution, please see SOL-613 . Example call: -- parameters : add_user_structure, add_rights, store_in_table execute script create_DDL( true , true , false );
    • Category 1:
      Database Administration
    • Category 2:
      Scripting

      Attachments

        Issue Links

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated: