Skip to Content

HANA DB: Multiple Schema Sharing Same DB objects

5 days ago


avatar image

Hi All,

We are pretty new to HANA DB. We have a scenario where our main web application is maintaining multiple data bases (currently in SQL Server) corresponding to each client. The DB objects (tables, stored procedures etc) are the same across all data bases, hence currently only one version of these objects needs to be maintained. We are switching to HANA now and planning to retain the same approach of one schema per client. However, the issue we are facing is maintaining the DB objects. Since HANA has schema name appended to each DB object, we will end up having one version corresponding to each client.

1. What is the best approach in this scenario, so that we dont have to maintain 'n' versions of DB objects?

2. Several blogs mentions that it is recommended to maintain separate schema for SLT replicated tables and BODS replicated tables. Why is this necessary? What is the downside if we maintain all tables in one schema?

Thank you,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers