Upgrade from 3.3.1 to 4.2.2: Lots of Documents

docderivative — Tue, 21 Apr 2015 15:43:00 GMT

HiWe have a large (we feel it's large) 3.3.1 Alfresco installation holding approx. 50 million documents. This installation runs on a single Linux machine and uses DB2 for its database.I am not sure how to proceed with the upgrade…Looking at the differences between 3.3.1 and 4.2.2 it seems that ther

Re: Upgrade from 3.3.1 to 4.2.2: Lots of Documents

docderivative — Wed, 22 Apr 2015 09:59:28 GMT

In particular… 3.3/org.hibernate.dialect.DB2Dialect/node-prop-serializable.sql


INSERT INTO t_alf_node_properties
   (
      node_id, actual_type_n, persisted_type_n, boolean_value, long_value, float_value,
      double_value, string_value, serializable_value, qname_id, list_index, locale_id
   )
   SELECT
      node_id, actual_type_n, persisted_type_n, boolean_value, long_value, float_value,
      double_value, string_value, serializable_value, qname_id, list_index, locale_id
   FROM
      alf_node_properties;
‍‍‍‍‍‍‍‍‍‍‍‍

This is a complete copy of 247 million rows which is 47GB.

Does that sound feasible?

topic Upgrade from 3.3.1 to 4.2.2: Lots of Documents in Alfresco Archive

Upgrade from 3.3.1 to 4.2.2: Lots of Documents

Re: Upgrade from 3.3.1 to 4.2.2: Lots of Documents