Hi,
I have a multiple database application and I am trying to create a single version number strategy.
-
Each time I update any one of the databases, I want to increment the individual “database version” number using the $TemplateBuild.
-
Each time something has changed, I want to increment the “Application Version Number”. This might mean that one or many databases have been updated.
I want to hide the fact that there are many databases with individual “database version” numbers. The clients only need to know that they are on the latest “Application Version”.
I do not want to update a database design note in a database that has not been updated, just to update the “Application Version” number, so I am considering that I would have to use a centralised “Release Management Database”, which could hold Release notes, for all clients.
I am going round in cirlces at the moment, trying to think of the best approach. Does any one have a strategy?
Thanks
Paul