Creating a Microsoft SQL Server database for IBM Content Navigator
You must point to an existing database when you configure and deploy IBM Content Navigator. You can reuse an existing database or you can create a Microsoft SQL Server database where you can create the IBM Content Navigator configuration table after you configure and deploy the web application.
Before you begin
This prerequisite task applies for traditional application server deployments only. For container deployments, the worksheet preparation steps do not apply.
About this task
You can modify the sample code that is provided in this task for your environment. However, at a minimum, you must provide values for the parameters that are specified in the sample code.
Worksheet parameter | Sample code variable to replace | Description | Value |
---|---|---|---|
Database name | @ECMClient_DBNAME@ | The name of the database where you will create the IBM Content Navigator configuration table. See your database documentation for naming restrictions. |
This task assumes that you are logged in to your database server with the appropriate permissions required to create a database on that server.
Procedure
To create a Microsoft SQL Server database for IBM Content Navigator:
Example
Sample code for creating a Microsoft SQL Server database for IBM Content Navigator:
-- IBM CONTENT NAVIGATOR MSSQL SQL Script
--
CREATE DATABASE @ECMClient_DBNAME@;