cancel
Showing results for 
Search instead for 
Did you mean: 

Database deployment - How does Alfresco know the changes to

shikarishambu
Champ in-the-making
Champ in-the-making
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.
2 REPLIES 2

mrogers
Star Contributor
Star Contributor
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.

shikarishambu
Champ in-the-making
Champ in-the-making
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?

TIA