Creating the database
Remedy with Smart IT (Smart IT) installer will create the database automatically. However, if you have database access restrictions and cannot allow the Smart IT installer to create a database, you can create a pre-existing database.
When you 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 Smart IT. Complete the previous steps, described in the following topics:
Required database schemas
Smart IT requires the following database schemas:
|Stores business data
|Stores system data
|(Required only if you are using chat in Smart IT) Stores chat data
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 create
Depending on the database you are using, follow the instructions in the corresponding topic:
- Creating the Microsoft SQL database
- Creating the Oracle database
- Creating the database for Windows authentication