Do you show what version the App is, and what version the Database is?

Last updated by Brady Stroud [SSW] about 1 month ago.See history

It is best practice to always include an applications version somewhere within the app, but do you also include the database version, its just as important!

LinkAuditor
Figure: Everyone shows the version number somewhere on their app

Let's see how to show the Database version:

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.

zsVersionTable 1710232021938
Figure: Example - SSW Link Auditor _zsDataVersion table

For SSW Link Auditor this can be seen in the table status section.

LinkAuditorVersion
Figure: Example - SSW Link Auditor Database version is 62

ChangeScripts
Figure: The Application keeps all the scripts in a folder called SQLScripts (this allows the application to upgrade itself and give the Reconciliation functionality)

Adam Cogan
Matt Wicks
Jack Pettit
We open source. Powered by GitHub