This task explains how to upgrade your existing SDL Contenta S1000D databases from SDL Contenta S1000D 5.0, 5.0.x, 5.1, 5.2, 5.3, 5.4, or 5.5 to SDL Contenta S1000D 5.6. Perform this task on an SDL Contenta Explorer administration client computer that has already been upgraded to SDL Contenta S1000D 5.6.
Before you begin
Before upgrading your databases to SDL Contenta S1000D 5.6, you must first:
- Upgrade your Contenta application server to SDL Contenta S1000D 5.6
- Upgrade your Contenta Web server SDL Contenta S1000D 5.6
- Upgrade your Contenta Explorer clients to SDL Contenta S1000D 5.6
- Upgrade your Contenta database to SDL Contenta 5.6 by running the upgrade_56 program. See SDL Upgrading Contenta Clients on Windows for more information.
Note: An SDL Contenta Explorer Administration client workstation is a workstation that was installed using the Custom option and has administrative programs in the Contenta_home/bin directory.
Restriction: Your databases must be at SDL Contenta S1000D version 5.0 or higher before you can upgrade them to version 5.6 as noted above. To verify this, in Contenta Explorer, click and navigate to . The ContentaS1000Dkeyword should be CaS_5.0 or higher.
When adding new templates to an existing database, the upgrade script creates a new container under and copies the new version of the templates into the new container. The templates in the default 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 container and copy the new ones into that container.
Procedure
- 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 (x86)\Microsoft SQL Server\Client SDK\ODBC4.
Important: This environment variable is used to resolve SQLCMD.EXE pathing and must be set before running the database maintenance scripts on the client machine.
- On a SDL 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_56.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.
Note: Include the
@sid only when the database you are upgrading is not in the default Oracle SID. To determine the default SID, in the Windows Registry, navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\XyEnterprise\Content@\5.0. The default SID is the value of the
XYE_PDM_DATABASE_SID key.
If upgrading a database in the default SID, use: -dbase db_name -sid OracleSID
If upgrading a database in a different SID, use: -dbase db_name@sid -sid OracleSID
- 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_56.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).
- To verify that the database upgrade program completed successfully, do the following:
- View the log file, particularly the last line which indicates whether the database upgrade program completed successfully.
Note: Any errors about removing tools may be ignored; these errors may occur when trying to remove a tool that does not exist.
- In SDL Contenta Explorer, click and navigate to .
The ContentaS1000D keyword should be CaS_5.6.
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.