3) Database Setup

Owned by Bernhard Wolkerstorfer (Unlicensed)
Last updated: Jan 16, 2017 by Christoph Zöttl (Unlicensed)

This section explains the configuration and installation of database including the initial schema and seed data.

Setup

Please make sure that fulltext services are installed (see System Requirements).

The following steps need to be performed to setup the eRecruiter database.

  1. Database
    1. Database should be named eRecruiter
    2. Data file should have an initial size of 500 MB, auto-grow by 100 MB without limit.
    3. Transaction log should have an initial size of 100 MB, auto-grow by 10% with 10 GB limit.
  2. Database User
    1. When using Windows authentication (connection through integrated security) the user should be selected from the operating system.
    2. When using SQL Server authentication the user should be named erecruiter with a strong password that does not expire.
    3. The default language should be set to German.
    4. The default database should be set to the database created in step 1.
  3. User Mapping
    1. Grant access to the database from step 1 with db_owner permissions.

Schema

After the database has been created and the user has been setup, execute the schema creation script provided in the installation support package.

Seed

After the database schema has been created, execute the database seed script provided in the installation support package.