Hi Raffaele,
I have used a RepositoryCopier based solution in my github project:
- https://github.com/woonsanko/recipe-for-hippo-db-migration
It should be a bit slower than a direct db migration tool - if
existing and feasible - but more reliable and safer.
In my recipe, there are some product specific steps, such as extra jar
files, but the solution itself is very generic and simply using the
Jackrabbit RepositoryCopier.
Regards,
Woonsan
On Wed, Feb 24, 2021 at 5:33 AM Raffaele Gambelli
<r.gambe...@westpole.it> wrote:
>
> Hi all,
>
> I'm on Jackrabbit 2.14.0, I have an Oracle based installation having a big
> DEFAULT_BUNDLE table, it is 61787 megabytes:
>
> PersistenceManager
> class="org.apache.jackrabbit.core.persistence.pool.OraclePersistenceManager
>
> with a file Datastore:
>
> DataStore class="org.apache.jackrabbit.core.data.FileDataStore
>
> I know there is at least one "breaking change", the following one where
> NODE_ID in PostgreSQL is splitted in two columns:
>
> PostgreSQL
> create table ${schemaObjectPrefix}BUNDLE (NODE_ID_HI bigint not null,
> NODE_ID_LO bigint not null, BUNDLE_DATA bytea not null, PRIMARY KEY
> (NODE_ID_HI, NODE_ID_LO))
>
> Oracle
> create table ${schemaObjectPrefix}BUNDLE (NODE_ID raw(16) not null,
> BUNDLE_DATA blob not null) ${tablespace}
>
> Do you know about any other changes, which could make more difficoult the
> data migration?
>
> I don't understand if org.apache.jackrabbit.core.RepositoryCopier is a
> solution in my scenario or if it would be too much slow and so if a different
> solution would be recommended, but I don't know which...
>
> Thanks for your support, best regards
> [https://westpole.it/firma/logo.png]
>
> Raffaele Gambelli
> WebRainbow(r) Software Developer
>
> P +390518550576
> M 3371641888
> E r.gambe...@westpole.it
> W https://westpole.webex.com/meet/R.Gambelli
> A Via Ettore Cristoni, 84 - 40030 Casalecchio di Reno
>
> [https://westpole.it/firma/website.png]<https://westpole.it>
> [https://westpole.it/firma/twitter.png] <https://twitter.com/WESTPOLE_SPA>
> [https://westpole.it/firma/linkedin.png]
> <https://www.linkedin.com/company/westpole-italia/>
>
> This email for the D.lgs.196/2003 (Privacy Code) and European Regulation
> 679/2016/UE (GDPR) may contain confidential and/or privileged information for
> the exclusive use of the intended recipient. Any review or distribution by
> others is strictly prohibited. If you are not the intended recipient, you
> must not use, copy, disclose or take any action based on this message or any
> information here. If you have received this email in error, please contact us
> (email:priv...@westpole.it) by reply email and delete all copies. Legal
> privilege is not waived because you have read this email. Thank you for your
> cooperation.
>
> [https://westpole.it/firma/ambiente.png] Please consider the environment
> before printing this email
