If the service pack installer contains a database update, you can run the scripts manually. Consult the ReadMe to determine if there is a database update. After you update the database, you should then run the installer to update the web server and the library.

To update the Knowledge Center database manually on an Oracle server:

1. From the Windows Start menu, open a Command Prompt window.
    
2. To update the schema using the AlterSchemaObjects.sql script located in \db scripts\ORACLE\KnowledgeCenter in the software installation files, enter the following at the command prompt:
    
   sqlplus - SQL*Plus is the command line application for Oracle Database.
    
   -s - Run SQL*Plus without SQL*Plus messaging.
    
   <adminuser> - The administrative user for the instance of the Oracle server.
    
   <adminpwd>@<instance> - The password for the administrative user and the name of the instance.
    
   <scriptlocation>\<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 - The password used for the schema owner account and the schema_app account.
     
   Statement with generic parameters:
   sqlplus -s <adminuser>/<adminpwd>@<instance> @"<script location>\<script name>" schema_owner password
    
   Example with default install parameters:
   sqlplus -s system/password@xe @"E:\Setup\db scripts\ORACLE\KnowledgeCenter\AlterSchemaObjects.sql" KUSER KUSER KMASTER KMASTER_TEMP
    
3. Confirm the parameters and run the script.

To update the Developer database manually on a Microsoft SQL server:

1. From the Windows Start menu, open a Command Prompt window.
      
2. To update the database using the AlterDBObjects.sql script located in \db scripts\MSSQL\KnowledgeCenter in the software installation files, 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 DBOwner="<owner name>" - The database account that owns the database.
      
   -v DBName="<database name>" - The name of the database to be upgraded.
    
   Statement with generic parameters:
   sqlcmd -E -S <servername> -i <scriptfile> –v DBOwner="<VALUE1>" -v DBName="<VALUE2>"
    
   Example with default install parameters:
   sqlcmd -E -S "mysqlserver" -i "E:\Setup\db scripts\MSSQL\KnowledgeCenter\AlterDBObjects.sql" -v DBOwner="KUser" -v DBName="KMASTER" 
      
3. Confirm the parameters and run the script.
      
4. Close the Command Prompt window.