/
Creating the Database
Document toolboxDocument toolbox

Creating the Database

Owned by Matthew Wren (Unlicensed)
Jan 29, 2024

On This Page:

Creating a Schema

SQLServer

SQL Server databases will be supplied and configured by ServicePower consultants.

Oracle

ServiceScheduling requires the use of a UTF-8 character set. The database user & schema below must be created in an Oracle database with the NLS_CHARACTERSET set to AL32UTF8 (using the CREATE DATABASE statement).

  1. Create a Database User.
  2. Create a Database Schema.

 

Preloaded Data

The following database tables are preloaded with a default set data. These data may or may not remain in place for use by your business, but the relevant tables are mentioned here.

DataDatabase Table
Postcode look up algorithms to support differing geographies/countries (e.g. UK/USA)sp046_postcode_patterns
Time zone datasp056_time_zones

Related content

14.1 Creating the Database
14.1 Creating the Database
ServiceScheduling 14.1
More like this
Install ServiceOptimizer Deploying ServiceOptimizer Creating the Database
Install ServiceOptimizer Deploying ServiceOptimizer Creating the Database
ServiceScheduling 14
More like this
Introduction 2
Introduction 2
ServiceScheduling 13.3
More like this