Compare - Compare - OnBase - Database Reference Guide - OnBase/Database-Reference-Guide/Foundation-23.1/Database-Reference-Guide/Installation/Database-Creation/Using-Foundation-DBUtils/Using-the-Foundation-DBUtils-User-Interface/Compare - Foundation 23.1 - Foundation 23.1

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License
ft:lastPublication
2025-08-21T22:01:17.527000
ft:locale
en-US

Navigate to the Compare tab. To compare the schema of an attached database to the defined schema related to Foundation DBUtils:

  1. Select a data source from the Data Source drop down list.
  2. To have detailed messaging and SQL statements logged to the window during database upgrade process, select Verbose.
  3. Select Output Index SQL to generate a SQL script for updating obsolete indexes identified during the comparison process.
  4. Click Compare.