• Apply Service Pack Database Updates Manually to the Developer Server
  • Apply Service Pack Database Updates Manually to the Developer Server
  • "ae7b1267-7a8d-429e-9060-a0f9debf99ea
  • If the service pack installer contains a database update, you can run the scripts manually. After you update the database, you should then run the installer to update the web server and the library.
  • If you are running the scripts on an Oracle Database server, it should be run by the schema owner account created at the installation of the Developer. If you are running the script on a Microsoft SQL Server, it should be run by an SQL administrator with either sysadmin or a combination of securityadmin and dbcreator privileges. The database objects creation does not necessarily require these privileges and could be performed by the user with db_owner privileges of the database. This would require modifications to the SQL scripts.
  • The installer files for the Service Pack are compiled into a self-extracting executable file. To run the scripts manually, you must extract the installer files.
  • Create an empty folder for the files.
  • Tip:
  • From the Windows Start menu, open a Command Prompt window.
  • To extract the files into the newly created directory, enter the following at the command prompt: /extract_all:<extraction location>. Be sure to include the path to the folder in the command.
  • To update the Developer database manually on an Oracle server:
  • From the Windows Start menu, open a Command Prompt window.
  • Update the schema using the
  • AlterSchemaObjects.sql
  • Warning!
  • Standard sqlplus syntax
  • Note:
  • Example with default install parameters
  • Confirm the parameters and run the script.
  • Enter
  • exit
  • ENTER
  • Enter
  • exit
  • ENTER
  • To update the Developer database manually on a Microsoft SQL Server:
  • From the Windows Start menu, open a Command Prompt window.
  • Update the database using the
  • AlterDBObjects.sql
  • Warning!
  • Standard sqlcmd syntax
  • Note:
  • Example with default install parameters
  • Confirm the parameters and run the script.
  • Enter
  • exit
  • ENTER