Installer 10.11 | Complete Installation and Upgrade Information for Software AG Products | Upgrading Software AG Products On Premises | Upgrade MashZone NextGen | Upgrade from 9.10 or 9.12: Migrate MashZone NextGen | Upgrade from 9.10: Add Data from the Old Repository to the New Repository
 
Upgrade from 9.10: Add Data from the Old Repository to the New Repository
MashZone NextGen 9.10 had two repositories, mashzonerepository and mashzonenextgenrepository. Starting with MashZone NextGen 9.12, there is only one repository, mashzonenextgenrepository. The new mashzonenextgenrepository already contains the data from the old mashzonenextgenrepository, but you must manually add the data from the old mashzonerepository.
1. Go to the new_Software AG_directory/MashZoneNG/apache-tomcat/conf directory and open the context.xml file. Add a <Resource> entry that sets the connection attributes properly for the old mashzonerepository. For example:
<Resource name="amzDatabase" auth="Container" type="javax.sql.DataSource"
maxTotal="200"
maxIdle="30"
maxWaitMillis="10000"
validationQuery="values(1)"
username="app"
password="app"
driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:
${catalina.base}/bin/mashzonerepository"/>
2. Go to the new_Software AG_directory/MashZoneNG/apache-tomcat/webapps/mashzone/WEB-INF directory, open the web.xml file in a text editor, and add this XML <resource-ref> element to the bottom of the file, just before the closing </web-app> tag:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>amzDatabase</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3. Start the MashZone NextGen server.
Data from the amzDatabase will automatically be migrated into the mashzonenextgenrepository, and amzDatabase will no longer be used.
4. Shut down the server.
5. Go to the new_Software AG_directory/MashZoneNG/apache-tomcat/webapps/mashzone/WEB-INF directory and open the web.xml file in a text editor. Remove the <resource-ref> element you just added and save the file.
6. Go to the new_Software AG_directory/MashZoneNG/apache-tomcat/conf directory and open the context.xml file. Remove the <Resource id="amzDatabase"> element and save the file.