Schema - Do you always have version tracking tables?
  v6.0 Posted at 7/11/2019 5:26 AM by Tiago Araujo

​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.​

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address: