The script package that ships with CaseTalk Server (installed into the SCRIPTS folder) now carries two scripts that compare a database against the complete column layout of that same package:

Detect-SchemaErrors.sql - read-only. Reports every table or column that is missing, too narrow, of another type, or unexpected. It changes nothing, so it can be run at any time.

Repair-Schema.sql - adds the missing columns and widens the narrowed ones, then checks again and reports whatever it could not settle by itself. Columns that are unexpected, or that have a different type than expected, are deliberately left alone: those can hold data, so removing or converting them stays a decision for the administrator.

Both are safe to run more than once, and neither touches the stored database version - a repaired database keeps the version it had.

The installation instructions in the package have a new section describing when and how to run them, and both the fresh install and the upgrade procedure now end by pointing at it. Running the report is the only way to establish that a layout is complete; the stored version does not prove it. The upgrade procedure also warns to check for errors after every script, since a failed step does not stop the version from being raised.