Do you show what version the App is, and what version the Database is?
Updated by Brady Stroud [SSW] 1 year ago. See history
Modern Applications
These days frameworks handle database versioning for us, using code first migrations we can tell the application to automatically update the database when it starts up so its always at the latest version.
Legacy Applications
For legacy applications that aren't using Frameworks such as EF, keeping track of a databases version can be done in the following way.
Create a new table that will store the version info, this table is often called _zsDataVersion.

Figure: Example - SSW Link Auditor _zsDataVersion table
For SSW Link Auditor this can be seen in the table status section.

Figure: Example - SSW Link Auditor Database version is 62

Figure: The Application keeps all the scripts in a folder called SQLScripts (this allows the application to upgrade itself and give the Reconciliation functionality)
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.