This document describes how the JCR of a WebManager 9.X.X installation that is stored in file system (or "derby" in JCR terms) can be transferred to a database.

1         Stop Webmanager (Tomcat).

2         Make a backup of the JCR on the local file system typically stored in the ..\work\jcr directory of the WebManager installation.

           This backup is a safety  precaution and will not be used later on.

3         Export the JCR with the jcr-import-export tool with the following command:

           (Please change the paths and WebManager version in this command to match your local installation.)

            java -Djava.util.logging.config.file=logging.properties -Xmx512M -jar jcr-import-export-tool-9.5.3.jar -c C:\GX\WM9\work\jcr\repository.xml -d C:\GX\WM9\work\jcr\repository\ -ns -nt -e export.zip

            More information about the jcr-import-export tool and how to install it is described in the document : "HOWTO COPY GX WEBMANAGER FROM ONE ENVIRONMENT TO ANOTHER" that can found here:

            http://www.gxdeveloperweb.com/Software/Documentation.htm

4         Empty the..\work\jcr directory that has been backed-up in step 1.

5         Generate a new repository.xml file:

           To generate a repository.xml file open the settings.xml file and change where the  JCR is stored from derby to e.q. mssql.

           After changing the settings.xml, run the following command:

           mvn -s C:\GX\WM9\settings.xml -P configure-jcr-repository

           This will generate a repository.xml file in the folder  ..\work\jcr. 

6         Import the export.zip created in step 3 with the following command:

           (Please change the paths in this command to match your local installation.)

            java -Djava.util.logging.config.file=logging.properties -Xmx512M -jar JcrImportExportTool-x.y.z*.jar -c C:\GX\WM9\work\jcr\repository.xml -d C:\GX\WM9\work\jcr\repository\ -ns -nt -i export.zip

7         Finished (Start WebManager).