Skip to Content

Transport HANA tables not using Imp/Exp

We want to transport HANA tables (in schema) from DEV to QAS. Some tables are created via SQL and some are created as Virtual Tables (SDI).

May I know how to transport them to QAS without using export/import? I have done some researches. It looks impossible for both. I don't want to create/transport XS program(script) to generate the objects in the target system.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 08 at 04:28 PM

    The best practice to create tables is to use design time artefacts. Design time artefacts can easily be transported (deployed) into other systems. The obvious recommendation would be to stop creating tables run time and start creating them design time. But since you haven't done that, and in case you don't want to, you will have to execute the same create statements on QAS as in DEV. So either get the create statements of each table, or use PowerDesigner or Enterprise Architect Designer to reverse engineer and push the SQL to the database.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi David, that is possible, that is because of .hdinamespace file. You can delete the namespace file from the group where the table exists in the project, name space is not mandatory unless if you wanted to specify the package hierarchy as the name prefix to your objects to identify them uniquely.

  • Mar 08 at 11:09 PM

    In XS classic (studio or the web development workbench) that is not possible. The package name is always part of the namespace.

    In XS advanced (Web IDE), the successor of XS classic, the namespace is optional, so you can name your tables anyway you want to.

    Add comment
    10|10000 characters needed characters exceeded