Schema - Do you always have version tracking tables?

Last updated by Brady Stroud [SSW] about 2 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.

We open source. Powered by GitHub