You can manually update the Knowledge Pathways database by running a script on the database server before you run the installer to upgrade the web server.
 

Warning: It is necessary to run the SQLPlus command line application for Oracle and the SQLCmd command line application for Microsoft SQL from the folder location that contains the script you are running. 

To upgrade the Oracle database manually and then upgrade the server: 

1. From the Windows Start menu, open a Command Prompt window.
    
2. Using the cd command, change into the folder where the scripts are located in the software installation files; for example, if the files are located on the C: drive in a temp folder:
    
   cd c:\temp\setup\db scripts\ORACLE\KnowledgeCenter
    
3. Enter sqlplus, and at the SQLPlus command prompt, enter the user name and password of the administrator account to connect to the Oracle database.
    
4. To update the schema using the AlterSchemaObjects.sql script, enter the following at the command prompt:
    
   <scriptname> - The path to the location of the script and the name of the script to be run.
    
   schema_owner - The schema owner name is limited to 20 characters.
    
   password - This will be the password used for the schema owner account and the schema_app account (this account is created automatically).
    
   tablespace - The name of the tablespace to be upgraded.
    
   temp_tablespace - The tablespace name with _temp.
     
   Statement with generic parameters:
   @"<script name>" schema_owner password tablespace temp_tablespace
    
   Example with default install parameters:
   @"AlterSchemaObjects.sql" KUSER KUSER KMASTER KMASTER_TEMP
    
5. Confirm the parameters and run the script.
    
6. Close the command prompt window.

To upgrade the Microsoft SQL database manually and then upgrade the server:

1. From the Windows Start menu, open a Command Prompt window.
    
2. Using the cd command, change into the folder where the scripts are located in the software installation files; for example, if the files are located on the C: drive in a temp folder:
    
   cd c:\temp\setup\db scripts\MSSQL\KnowledgeCenter
      
3. To upgrade the database using the AlterDBObjects.sql script, enter the following at the command prompt: 
    
   sqlcmd - The command line application for the Microsoft Sequel server.
    
   -E - Use a trusted connection to the Microsoft Sequel server. To use a login and password, use the -U <LOGINID> -P <password> parameters.
    
   -S <servername> - The name of the Microsoft SQL server.
    
   -i "<scriptfile>" - The path to the script file and the name of the script file.
        
   -v DBName="<database name>" - The name of the database to be upgraded.
    
   Statement with generic parameters:
   sqlcmd -E -S <servername> -i <scriptfile> -v DBName="<VALUE1>"
    
   Example with default install parameters:
   sqlcmd -E -S "mysqlserver" -i "AlterDBObjects.sql" -v DBName="KMASTER" 
      
4. Confirm the parameters and run the script.
    
5. Close the Command Prompt window.

Table of Contents