How to Create Tenant Database in SAP HANA

How to Create Tenant Database in SAP HANA

In this post we will learn How to Create Tenant Database in SAP HANA. Tenant database is not like a system database. System database is mainly used to manage the overall system, and tenant database is used to store your development artifacts. In tenant database we can add services that process the data, while system database do have restrictions.

Tenant database is like a user database. There can be multiple tenant database in a system. Earlier we discussed about Start SAP HANA Database | Stop SAP HANA Database.

Create Tenant Database in SAP HANA Script:

- - create tenant database - -

CREATE DATABASE TESTING SYSTEM USER PASSWORD DeMO1234;

- - add the script server service - -

ALTER DATABASE TESTING ADD 'scriptserver'

- - start tenant database - -

ALTER SYSTEM START DATABASE TESTING 

- - stop tenant database - -

ALTER SYSTEM STOP DATABASE TESTING 

Create Tenant Database in SAP HANA Video Tutorial: