Transport HANA tables not using Imp/Exp

[former_member601762]

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.

[Sefan_Linders · Accepted solution]

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.

[former_member601762 · Accepted solution]

Thanks Sefan. Another question:

We created a table by creating "hdbtable" file under a package. But I found the table name is "package name"::"filename".

We don't want the "package name" and "::". We just want the table under the schema. Is it possible?

[ssurampally · Accepted solution]

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.

[Sefan_Linders]

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.