Secret ingredients to quality software

Schema - Do you always have version tracking tables?

Last updated by SSW.Rules.SharePointExtractor on 22 Feb 2021 02:04 am (9 months ago) See History

We always use two tables for tracking versioning information:

  • _zsDataVersion tracks the schema changes, and which update script we are up to. This helps tremendously in determining which version of the scripts are still required between development, test, and production databases.
  • _zsVersionLatest tracks which version the front-end client should be. This allows us to give a warning to (or even deny) users who are connecting to the database while not using the right version of the front-end client.

Please see "Is a Back-end structural change going to be a hassle?" on our Rules to Successful Projects.

Adam CoganAdam Cogan

We open source. Powered by GitHub