Upgrading a Microsoft SQL Server Archiver database manually

If you have a pressing reason to not use the PowerShell script, you can also upgrade your SQL Server Archiver database manually by running the SQL scripts yourself. You must run these scripts as a properly authorized user (that is, someone who can create tables, for example). Later, when you upgrade the Archive Manager Core, you need to run an additional tool to update the timestamps in the database.

Procedure

  1. On your installation media, navigate to \Database\Scripts\MSSQL\.
  2. Only if you are upgrading from Archive Manager 1.0, run the following SQL script:
    • Upgrade\10_10SP1\TAM_UPDATE_CREATE.sql
    • Shared\10SP1\TAM_SET_VERSION.sql
  3. Only if you are upgrading from Archive Manager 1.0 or from Archive Manager 1.0 SP1, access the 10SP1_10SP2\ subfolder and run the following SQL script:
    • Upgrade\10SP1_10SP2\TAM_UPDATE_TABLES.sql
    • Shared\10SP2\TAM_SET_VERSION.sql
  4. Always access the 10SP2_10SP3\ subfolder and run the following SQL scripts:
    • Upgrade\10SP2_10SP3\TAM_UPDATE_TABLES.sql
    • Upgrade\10SP2_10SP3\TAM_UPDATE_CONSTRAINTS.sql
    • Upgrade\10SP2_10SP3\TAM_UPDATE_INDEXES.sql
    • Shared\10SP3\TAM_SET_VERSION.sql