Exportar una taula d’un esquema a un directori del servidor HANA, sobre escrivint les dades que hi pugui haver al directori:

EXPORT "A20174_ECOALF_PRODL"."OUSR" AS BINARY INTO '/usr/sap/NDB/HDB00/work/DMB' WITH REPLACE

Importar un esquema i planxar-lo amb un altre nom:

IMPORT "A20174_ECOALF_GERMANY"."*" AS BINARY 
FROM '/usr/sap/NDB/HDB00/work' 
WITH REPLACE THREADS 10 
RENAME SCHEMA "A20174_ECOALF_GERMANY" TO "A20174_ECOALF_HOLLAND";

Export-Import Statements

Execute the following statements in the SAP HANA studio to export and import a schema. You may choose to import a schema directly or import the schema with a different name.

  • Export statement: 
          EXPORT “SCHEMA_NAME”.“*” AS BINARY INTO ‘export_path’ WITH REPLACE THREADS 10;
    Example:
          EXPORT “SBODEMOUS”.”*” AS BINARY INTO ‘/usr/backup’ WITH REPLACE THREADS 10;
  • Import statements:
    1. IMPORT “SCHEMA_NAME”.“*” AS BINARY FROM ‘import_path’ WITH IGNORE EXISTING THREADS 10;
      Example:
            IMPORT “SBODEMOUS”.”*” AS BINARY FROM ‘/usr/backup’ WITH IGNORE EXISTING THREADS 10;
    2. IMPORT “SCHEMA_NAME”.“*” AS BINARY FROM ‘import_path’ WITH IGNORE EXISTING THREADS 10 RENAME SCHEMA “SCHEMA_NAME” TO “NEW_SCHEMA_NAME”;
      Example:
         IMPORT “SBODEMOUS”.”*” AS BINARY FROM ‘/usr/backup’ WITH IGNORE EXISTING THREADS 10 RENAME SCHEMA “SBODEMOUS” TO “SBOTEST”;

Note: When importing a schema, use the “WITH IGNORE EXISTING” option (which is available as of SAP HANA 1.0 SPS 07).
Do NOT use the “WITH REPLACE” option for import on a productive environment. SAP Business One company schemas usually reference objects in the SBOCOMMON system schema, or there could be dependencies on other schema objects because of hardcoded schema names within stored procedures. Using the “WITH REPLACE” option would overwrite the contents of the referenced objects in SBOCOMMON or in any other dependent schema and could cause problems (possibly causing data overwrite).

Font: https://launchpad.support.sap.com/#/notes/2134959
(Atenció, fa falta S-USER)