VERIFIED SOLUTION i

How to perform a database schema check in Confirm

Products affected: Confirm®
Product feature: Application Infrastructure, Installation/Upgrade

 

The Database Schema Check examines the schema of the database, and compares it to the expected schema for the version of Confirm® you are running.

It will report errors such as columns missing from the database or defined as the wrong data type. These errors can cause the software to crash or can have serious performance implications. Any errors should be reported to Pitney Bowes by raising a new case with the Confirm Technical Support team.

It will also report warnings such as additional/optional columns in tables. These may be valid differences introduced intentionally to a particular database in which case your database administrator should be aware of them. If unexpected warnings are reported, or if in doubt, these should also be reported to Pitney Bowes by raising a new case with the Confirm Technical Support team.

It is recommended that a Database Schema Check is carried out prior to any Confirm upgrade to detect issues that might impact the successful upgrade of the database schema. It is also recommended that a Database Schema Check is carried out after any Confirm upgrade to ensure the schema has been upgraded correctly.

UPDATED:  July 4, 2017