Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments. Click here to view the documentation for the current version.

Pre-creating database

The following topics are provided:

Purpose

If you have database access restrictions and cannot allow the BMC MyIT and BMC Remedy with Smart IT (Smart IT) 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. 

Required database schemas

BMC MyIT and Smart IT require the following database schemas:

SchemaPurposeContains
schemaName_businessStores business data
  • Location
  • Certificates
  • Configuration
  • Customizations
  • Images
schemaName_systemStores system data
  • Provider Info (from SmartIT and MyIT)
  • Tenant
  • Plugin
openfire(Required only if you are using chat in Smart IT) Stores chat data

The database tables above start out small and grow to a size but the size is much small when compared to ITSM DB or MongoDB.

You can replace schemaName with SmartIT 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 click on the topic:

Was this page helpful? Yes No Submitting... Thank you

Comments