topic versioning implementation in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/versioning-implementation/m-p/232893#M186023 <HTML><HEAD></HEAD><BODY><SPAN>I'm wondering if it's possible that someone from the alfresco team could describe how versioning in implemented in the alfresco 2.1 from the database point of view. I want to compact our database and</SPAN><BR /><SPAN>I'm thinking of deleting old history of the nodes. I prefer to do it directly by sql scripts so I can move the rows somewhere and keep them as a backup. I do not want to change/reset versionLabels and I hope that upgrade in the future will be possible</SPAN><BR /><SPAN>I found that versioned data are stored in alf_node, alf_child_assoc and alf_node_properties but it's not easy to understand how it's working. Usually it's not a problem but this database is too generic</SPAN><BR /><SPAN>I've even attached spy jdbc driver but hey there're about 300-500 statements generated during creating new version of a node</SPAN><BR /><SPAN>I can see that deleting specific version from the java code is not supported in 2.1 either. I don't know was it too difficult ?</SPAN></BODY></HTML> Wed, 23 Sep 2009 21:50:37 GMT ra74 2009-09-23T21:50:37Z versioning implementation https://connect.hyland.com/t5/alfresco-archive/versioning-implementation/m-p/232893#M186023 I'm wondering if it's possible that someone from the alfresco team could describe how versioning in implemented in the alfresco 2.1 from the database point of view. I want to compact our database andI'm thinking of deleting old history of the nodes. I prefer to do it directly by sql scripts so I can Wed, 23 Sep 2009 21:50:37 GMT https://connect.hyland.com/t5/alfresco-archive/versioning-implementation/m-p/232893#M186023 ra74 2009-09-23T21:50:37Z Re: versioning implementation https://connect.hyland.com/t5/alfresco-archive/versioning-implementation/m-p/232894#M186024 <HTML><HEAD></HEAD><BODY><SPAN>Hi ra74,</SPAN><BR /><BR /><SPAN>you should investigate the structure of the version store in the node browser first. That gives a good hint how the database is organized. Before making even trivial changes you should back up your database… bad experiences <img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /></SPAN><BR /><BR /><SPAN>VersionHistory is - as far as I know - a more conceptual than a technical thing. Simply the accumulation of the versions which is not stored explicitly.</SPAN><BR /><BR /><SPAN>Good Luck,</SPAN><BR /><SPAN>Tim</SPAN></BODY></HTML> Mon, 28 Sep 2009 11:28:24 GMT https://connect.hyland.com/t5/alfresco-archive/versioning-implementation/m-p/232894#M186024 tim-erwin 2009-09-28T11:28:24Z Re: versioning implementation https://connect.hyland.com/t5/alfresco-archive/versioning-implementation/m-p/232895#M186025 <HTML><HEAD></HEAD><BODY><SPAN>I've analysed the source code and now I understand how it's working and I belive I can delete old history of the node except a few last history entries</SPAN><BR /><SPAN>But I'm not sure if it's safe </SPAN><BR /><SPAN>- what about content files - will they be deleted by the cleaner job ?</SPAN><BR /><SPAN>- what about lucene indexer - are they indexed at all ?</SPAN><BR /><SPAN>- what about upgrades in the future</SPAN></BODY></HTML> Mon, 12 Oct 2009 18:06:51 GMT https://connect.hyland.com/t5/alfresco-archive/versioning-implementation/m-p/232895#M186025 ra74 2009-10-12T18:06:51Z