Upgrade › Install the Software Upgrade

Install the Software Upgrade

To upgrade the software to a new version you must log in to your DBMS. To create, update, or delete a mart in CA ERwin Data Modeler Workgroup Edition, 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 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.

To install the software upgrade

1. Close all client connections and either insert the installation DVD or double-click the file you downloaded from the online CA product page.

   The Installation Wizard opens.

2. Follow the prompts in the wizard to proceed to perform an upgrade.

   When the install completes, a final screen displays.

3. Click Close.

Note: You may be required to reinitialize the mart to complete the upgrade process. For more information see Convert or Update a Mart.