Documentation PI Nexus+ Documentation

PI Nexus+ / Installation and Administration

22. Schema Migrations

Schema migrations update the PI Nexus+ database structure to match the installed application version. PI Nexus+ requires a compatible schema before scans can run.

Overview

Schema migrations update the PI Nexus+ database structure to match the installed application version. PI Nexus+ requires a compatible schema before scans can run.

The database setup script applies the initial schema during installation. After installation, PI Nexus+ checks and applies pending migrations when the web application starts and a valid bootstrap.json file is present. Software upgrades therefore normally update the database schema automatically when the configured service account has SQL access.

If a scan is blocked because the schema is not ready:

  1. Go to Admin > SQL.
  2. Confirm SQL Server and database name.
  3. Click Apply.
  4. Confirm schema status is compatible.
  5. Recycle PINexusAppPool and restart the PI Nexus+ Scanner service if needed.

Do not manually edit migration records unless instructed by support. Migration history is how PI Nexus+ knows whether the database structure matches the application.

A good result for this section is that Admin > SQL reports the database as reachable and compatible.