Create the INOW database - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Install Guide

Perceptive Content
Perceptive Content Database Install Guide
Foundation 24.1

To create the INOW database on Microsoft SQL Server, complete the following steps.

  • Verify the data directory for Microsoft SQL before creating the database. This is the directory where the database files appear after you execute the following SQL file. If you do not want the location of the INOW database files to reside in the default data directory, use the appropriate locations for each of the three file names.
  • Depending on the environment type you are creating, SunflowerSS.sql in the steps below can refer to SunflowerSS.sql or SunflowerSS_Unicode.sql.
  1. In SQL Server Management Studio, in the Object Explorer, select the master database. The master database is located under the System Databases folder.
  2. In the File menu, select Open, and then select File.
  3. In the Open File dialog box, navigate to the location that contains the SunflowerSS.sql file, select the SQL file, and then click Open.
  4. If the system prompts you to connect to the database, enter credentials for a user that has the sysadmin server role, and select Connect to make the connection.
  5. In the SunflowerSS.sql file, update the pathsspecified in the Create Database and the Alter Database commands to indicate the desired location of the database files. You must change the path after 'FILENAME = N' to the full path (drive, directory, and filename with extension) for all three files.
    • The directories you specify must already exist.
    • The Primary file group (INOW_Data mdf) contains all the tables (clustered indexes).
    • The Secondary file group (INOW_Index.ndf) contains all the non-clustered indexes.
    • The Log file (INOW_Log.ldf) contains records of modifications made by each transaction.
  6. To execute the query batch file, in the Query menu, select Execute. The execution is finished when the completion message appears at the bottom of the Query window.