schema export

[Former Member]

Hello, Does it possible to export an schema from one business suite on hana and after that importing it in another hana system and the first SAP Businness suite to point to second hana system with its own schema imported? Regards

[Bojan-lv-85]

Hello Ruben,

its possible:

- on source HANA: export the desired schema

- on target HANA: import the exported scheme into the desired target schema

On the SAP application-server as <sid>adm user adjust the hdbuserstore:

hdbuserstore set default <dbhost>: <dbport> <dbuser> <dbpassword>

                       Replace the information in the angle brackets as follows:

                        <dbhost>: The host name of the target database server

                        <dbport>: The port of the target database server

                        <dbuser>: The database user for the copied schema

                        <dbpassword>: The password of the database user

BR, Bojan

[Former Member]

Thanks Bojan Where I need to execute hdbuserstore in target system? Regards

[Bojan-lv-85]

on the SAP application server, the hdbuserstore is actually containing the db-connection information