Documentation Center

Upgrading a Contenta S1000D database

This describes upgrading an existing Contenta S1000D database from Contenta S1000D 5.3, 5.4, 5.5, 5.6, 5.7, or 5.8 to Contenta S1000D 5.9. Perform this task on an Contenta Explorer Administration client that has been upgraded to Contenta S1000D 5.9.

Before you begin

Before upgrading databases to Contenta S1000D 5.9, you must upgrade the following servers and clients to Contenta S1000D 5.9.
  • Contenta application server
  • Contenta Web server
  • Contenta Explorer clients
In addition, if you haven't already done so, upgrade the Contenta database to Contenta 5.6 by running the upgrade_56 program. See the Contenta installation documentation for more information.
When adding new templates to an existing database, the upgrade script creates a new container under S1000D > Templates and copies the new version of the templates into the new container. The templates in the default S1000D > Templates container are not modified or replaced.
  • If you have customized your templates, you must edit the new templates to include the customizations.
  • To use the new templates as the default, remove the current templates in the default S1000D > Templates container and copy the new ones into that container.

Procedure

  1. If your site uses Microsoft SQL Server, set the MSSQL_HOME system environment variable on the client machine to the full path to the MS SQL Server installation, such as C:\Program Files\Microsoft SQL Server\Client SDK\ODBC4.
  2. On a Contenta Explorer Administration client workstation, from a command prompt, navigate to the Contenta_home/bin/Upgrade_S1000D directory, and enter the following command, with the appropriate switches for your database:
    • For an Oracle database:
      upgrade_S1000D_59.pl -n node -user user -pw password -dbase <dbase|dbase@sid> -s socket-sid OracleSID [-dbpw dbase_password] [-help]
      where:
      • node is the name of the Contenta server.
      • user is sysadmin.
      • password is the Contenta sysadmin password.
      • dbase@sid is the name of the database and Oracle SID to be upgraded.
      • socket is the port number of the portal (PcmPortal).
      • OracleSID is the Oracle database SID.
      • dbase_password is the database password. This switch is required only when the database you are upgrading does not use the default database password (pdmuser).
    • For a Microsoft SQL Server database:
      upgrade_S1000D_59.pl -n node -user user -pw password -dbase dbase -s socket -dsn dsnserver -sqlsrv SQLServerNamedInstance [-dbpw dbase_password] [-help]
      where:
      • node is the name of the Contenta server.
      • user is sysadmin.
      • password is the Contenta sysadmin password.
      • dbase is the name of the MS SQL Server database to be upgraded.
      • socket is the port number of the portal (PcmPortal).
      • dsnserver is the Windows ODBC_DSN data source name. If not specified, the default is used-as defined in the registry for XYV_PDM_ODBC_DSN.
      • SQLServerNamedInstance is the SQL Server name with instance, if configured.
      • dbase_password is the database password. This switch is required only when the database you are upgrading does not use the default database password (pdmuser).
  3. To verify that the database upgrade program completed successfully, do the following:
    1. View the log file, particularly the last line which indicates whether the database upgrade program completed successfully.
      • The log file is in the Contenta_home/bin/Upgrade_S1000D directory.

        The log name is unique to the database: upgrade_S1000D_59-database.log

      • If an upgrade step fails, the program continues if possible.
      • The database upgrade program may be run multiple times on a database; it only performs steps that have not already been done.
      • The program detects if a step has already been done and skips it. The log indicates when a step has been skipped.
    2. In Contenta Explorer, select Tools > Options > Tool Preferences and navigate to Global > DB Schema. Alternatively, in Contenta Web, as the sysadmin user, select Edit AppData and navigate to Global > DB Schema.

      The ContentaS1000D keyword should be CaS_5.9.

What to do next

After upgrading your Contenta S1000D database, modify new or upgraded AppData settings as needed. See Modifying AppData settings after installing or upgrading Contenta S1000D.