Updating the Microsoft SQL Server database

When you update your Spotfire Server to a newer version, any user action database logging you have configured earlier will most likely continue to work, but to add new views you must perform additional steps.

Prerequisites

You must have credentials to the action log database.

Procedure

  1. In the new installation kit directory, browse to \scripts\mssql_install\actionlog.
  2. Using a text editor, open the script file create_actionlog_db.bat (on Windows) or .sh (on Linux).
  3. In the file, remove the section "Create the Spotfire Action log database user". Then, enter the information for CONNECTIDENTIFIER, ACTIONDB_USER, and ACTIONDB_PASSWORD.
  4. Run the edited script the same way as when you enabled the database logging.
    Tip: If you are familiar with SQL tools, you can instead open create_actionlog_db.sql for editing, remove the lines above use $(ACTIONDB_NAME), and change this line to use spotfire_actionlog. Then, log in to the database spotfire_actionlog and run the edited SQL directly.
    The SQL checks to see whether the table exists, and, if it does, creates only the views.

What to do next

The installation kit also includes a library import file, which contains information links for logging categories, as well as a sample Spotfire analysis file, which you can use to gain insight about your system. See Importing a library to Spotfire Analyst for analyzing action logs for more information.