Upgrade › Software Upgrades

Software Upgrades

New versions of the software and supported client software products are periodically released. The upgrade process prepares the tables and stored procedures to accommodate new functionality and client functionality, but does not change or delete any data stored in the mart. To upgrade the software, you must be assigned to the Administrator security profile and logged on to the DBMS.

To create, update, or delete a mart you must have the following database rights:

• For Microsoft SQL Server 2000/2005/2008, you must be the database owner (dbo).

  Notes:

  • The dbo is no longer required to also have the sysadmin role.
  • The SQL Server 2005/2008 TRUSTWORTHY database property is no longer required for the mart. After you install this product, you can optionally reset this property to OFF.
• For Oracle, you must be the database schema owner and have the DBA role.

The software should be installed or upgraded on the computer that houses the license information. This workstation is typically the same computer that the mart administrator uses or the first computer that was used to install the software.

Note: For some software upgrades, a new license is required.

The mart upgrade process is slightly different depending on your DBMS. For more information about specific procedures, see the particular section on the database you are running.