topic Database deployment - How does Alfresco know the changes to in Alfresco Archive

Database deployment - How does Alfresco know the changes to

shikarishambu — Tue, 12 Jan 2010 23:45:28 GMT

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.

Re: Database deployment - How does Alfresco know the changes to

mrogers — Tue, 12 Jan 2010 23:54:48 GMT

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.

Re: Database deployment - How does Alfresco know the changes to

shikarishambu — Thu, 14 Jan 2010 23:05:24 GMT

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