Cora Knowledge Center

Support

Installing DB Scripts for Cora SeQuence V9.0

V9.0

You set up the Cora SeQuence database using scripts.

Before you begin

Before you install the DB scripts, make sure that:

 The SQL server is setup.

Available DB scripts

ScriptDescription
01 - Create Database.sqlCreates the database and sets its properties.
This script runs only on supported versions and editions of the SQL server.
Default database name: CoraSeQuence
02 - Create Objects.sqlCreates all the database objects: schemas, stored procedures, tables, and functions, among other objects.
03 - Insert Data.sqlInserts all the “template” data required for Cora SeQuence to work properly.
Install HotOperations.sqlRequired for the Cora SeQuence Premium version, which includes HotOperations. 

Install the DB scripts

  1. Download the DB Scripts.
  2. Run the following scripts:
    • 01 - Create Database.sql
    • 02 - Create Objects.sql
    • 03 - Insert Data.sql
  3. For Premium versions, also run this script: Install HotOperations.sql

Database files are installed in default locations, as configured on the SQL server. If required, after installation, you can move the files using the standard procedure.

Change database name

If you need to change the name of the database, do the following before you run the script: 01 - Create Database.sql 

  1. To change the name of the database, open the script 01 - Create Database.sql, and run Find/Replace.


Next steps

To continue, you can do one of the following: