V9.2
You set up the Cora SeQuence database using a PowerShell function. You can use this function for deploying a new database or updating V9.0 and later databases.
Before you begin
Before you deploy the database, make sure that:
The SQL server is setup.
The latest PowerShell modules are installed.
Click here to view a sample PowerShell script. Consider this sample for reference only, and do not copy paste from here.
Procedure
- Run the Install-CoraSeQuenceDatabase function.
NOTE
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.
Next steps
To continue deploying Cora SeQuence, do one of the following:
- To install pre-built applications, see this article.
- To build your own applications, see this article.
V9.0-V9.1
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
| Script | Description |
|---|---|
| 01 - Create Database.sql | Creates 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.sql | Creates all the database objects: schemas, stored procedures, tables, and functions, among other objects. |
| 03 - Insert Data.sql | Inserts all the “template” data required for Cora SeQuence to work properly. |
| Install HotOperations.sql | Installs Hot Operations components. Required for the Cora SeQuence Premium version, which includes HotOperations. |
Install the DB scripts
- Download the DB Scripts.
- Run the following scripts:
- 01 - Create Database.sql
- 02 - Create Objects.sql
- 03 - Insert Data.sql
- 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
The default database name is CoraSeQuence. If required, you can change the name of your database.
Perfom the following procedure before you run the script: 01 - Create Database.sql
- Open the script 01 - Create Database.sql, and run Find/Replace:
- Find: CoraSeQuence
- Replace: the new database name
Next steps
To continue deploying Cora SeQuence, do one of the following:
- To install pre-built applications, see this article.
- To build your own applications, see this article.
