We are new to Hana DB and have begun building a Hana DB connector for our existing application for an existing client using SAP B1 with Hana DB. Our application just needs to connect to Hana DB and execute some basic SQL SELECT queries. We want to restore the Hana DB data structure schema (i.e., Tables, fields, etc.) in our devtest environment based on the new client configuration so that we can create and configure these queries on our side.
Is there a recommended way to quickly export or dump Hana DB, or just the structure or structure, or their current test data installed in the database and then recreated on our side?
As an example in MySQL, this would be so simple:
- Test the client side:
mysqldump -h host -uuser -p database_name > database_name.sql - Our side of DevTest:
mysqladmin -h host -uuser -p create database_name - Our side of DevTest:
mysql -h host -uuser -p database_name < database_name.sql
Is there an equivalent of the above steps for Hana DB?
Are there both GUI tools and command line tools mentioned above that will already be installed on the Windows computer on which they are installed?
If our test client runs on Windows and we intend to configure our DevTest Hana DB on Linux, are there tools and syntax for exporting / importing the same?
Will there be any differences if we intend to use the SAP Hana Express Edition from the Docker Store for our DevTest environment, and our client is most likely to use the full-blown edition of SAP Hana. Are database structures and commands / tools and syntax the same?
source
share