Schema - Do you always have version tracking tables?
7/11/2019 5:26 AM by
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.
Do you feel this rule needs an update?