Pre-creating the database
If you have database access restrictions and cannot allow the BMC Digital Workplace installer to create a database, you can create a pre-existing database.
When you pre-create a database, you create database users and assign required roles to them.
The following topics are provided:
Before you begin
This topic is part of Preparing for installation of Digital Workplace. Complete the previous steps, described in the following topics:
- Installation worksheets for Digital Workplace
- Downloading the BMC Digital Workplace installation files
Required database schemas
BMC Digital Workplace require the following database schemas:
|schemaName_business||Stores business data||
|schemaName_system||Stores system data||
The database tables above start out small and grow to a size but the size is much small when compared to the ITSM DB.
You can replace schemaName with DWP or any other identifier that you prefer. BMC recommends that you keep "_business" and "_system" as part of these schema names so that you can easily identify the data in the tables. During installation, you can specify these schemas.
Databases you can pre-create
Depending on the database you are using, follow the instructions in the corresponding topic: