Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-231

Copy Database script

    XMLWordPrintable

    Details

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

      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.

      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.

      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
      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. 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. 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: