Database configuration

OCRIS Toolbox needs to connect to an SQL Server database running the OCRIS Standard Model.

Creating a database

Microsoft's official documentation has a section detailing how to create a SQL Server database (opens in a new tab)

Your database must use the Latin1_General_CI_AS collation, as described in the collation section below.

The simplest way to create your database is to run the SQL below. However, your system may have some more advanced requirements, so it is best to leave the database creation up to your system administrator or OCRIS consultant.

CREATE DATABASE YOUR_DATABASE_NAME COLLATE Latin1_General_CI_AS;

Collation

The database must have the Latin1_General_CI_AS collation.

To check your server collation, you can run the following SQL:

SELECT CONVERT (varchar(256), SERVERPROPERTY('collation')) AS [ServerCollation];

To check the collation of all databases on your server, you can run the following SQL:

SELECT [name], [collation_name] FROM [sys].[databases];