Creating a Database Manually

In your database server machine, run the following database scripts sequentially using SQL Server Management Studio.

The scripts are located under %EMS_HOME%\Database\SQL Scripts\ManualDBCreationScripts in your Sentinel LDK-EMS server.

These scripts create a database named EMSDB. If you want to create a database with a different name, modify the default database name value in the USE [EMSDB] line before running the scripts.

>Step1_CreateDB.SQL

>Step2_CreateTables.SQL

>Step3_SeedMasterData.sql (Modify your Tomcat ports, if needed.)

>Step4_SeedLDKAttributes.sql

>Step5_SeedCLOUDAttributes.sql

>Step6_EMS_DB_SEED_LDKSAAS.sql

>Step7_SeedDemoData (Optional).sql (Optional. Run this script only if you want to enter demo data for evaluation or test purposes.)

NOTE   Sentinel LDK-EMS supports non-case-sensitive databases and English collation. Collation specifies the rules used to sort and compare characters, for example, language, case sensitivity, accent sensitivity, and so on.

For details on pointing to this database from Sentinel LDK-EMS, see Updating Database Connection Details.