| Subject | Best place to store schema version for use by update procedures? |
|---|---|
| Author | mlq97 |
| Post date | 2007-06-10T14:32:32Z |
Where is the best place to store the schema version of a database? At
present I have created a 1 row table with a column to store the number.
But when comparing two schemas to automatically create an update
script, the schema numbers are not automatically visible.
Is there a better way to do this, perhaps in a constant or something?
What is the standard way of doing this?
Mitch
present I have created a 1 row table with a column to store the number.
But when comparing two schemas to automatically create an update
script, the schema numbers are not automatically visible.
Is there a better way to do this, perhaps in a constant or something?
What is the standard way of doing this?
Mitch