I have noticed that Alfresco while starting up checks to see if the database is up-to-date and if not runs scripts to update the database. How does Alfresco keep track of the code to db mapping/ version numbers. And, what does it use to apply only the relevant scripts.
There's a 'schema number' for each release of alfresco. When alfresco starts up it compares the schema number of the code with the schema number of the database and applies any patches required. There's data in the database to say which schema was originally installed and which patches have been applied.
Thanks for the information. Does Alfresco use any open source tool/library to do this? Or, is it part of the Alfresco code base. Also, what is the name of the table in the db that stores this schema information?