Upgrade to MS SQL Server 2025

If Foray ADAMS® is being upgraded to MS SQL Server 2025 from an earlier version the full text index must be rebuilt after restoring the DB.

SELECT name, compatibility_level
FROM sys.databases
WHERE name = '<foray_db>';

Compatibility levels

Level	Database

SELECT OBJECT_NAME(object_id) AS table_name, index_version
FROM sys.fulltext_indexes;

SELECT *
FROM sys.database_scoped_configurations
WHERE name = 'FULLTEXT_INDEX_VERSION';

This will be 1 for DBs before 2025 and for restored DBs on 2025 before they are rebuilt.

ALTER FULLTEXT CATALOG [foray_adams_full_text_catalog] REBUILD;

After this is complete check the index version. It should now be 2.