Creating EMS Database manually by using SQL Scripts

We can create EMS Database manually by using some SQL Scripts. 

In  database server machine, run the following database scripts using SQL Server Management Studio in the given sequence. The scripts are available at %EMS_HOME%\Database\SQL Scripts\ManualDBCreationScripts in Sentinel EMS Server.

 

  1. CreateDB.SQL (For creating new database)
  2. CreateTables.SQL (For creating Tables in database)
  3. SeedMasterData.sql (Import master data/ database schema)
  4. SeedLDKAttributes.sql (Import LDK relational attributes)
  5. SeedCLOUDAttributes.sql (Import Cloud attributes)
  6. SeedDemoData (Optional).sql  (Optional Script, If we want to fill Demo data)