Complete Installation and Upgrade Information for Software AG Products : Upgrading Software AG Products : Migrate MashZone NextGen : Migrate MashZone NextGen : Set Up the MashZone NextGen Repository : Set Up Repository When Using Any Other Database
Set Up Repository When Using Any Other Database
If you used MySQL, Oracle, PostGres, or SQL Server for your old repository, follow the instructions below.
1. Go to the old_Software AG_directory/{Presto|MashZoneNG}/apache-tomee-jaxrs/lib directory and copy the JDBC driver jar file for your database to the new_Software AG_directory/MashZoneNG/apache-tomcat/lib directory.
Database
JDBC Driver Jar File
MySQL
mysql-connector-java-5.1.31.jar
Oracle
ojdbc6.jar
PostGres
postgresql-9.2.1004.jdbc4.jar
SQL Server
jtds-1.3.1.jar
2. If you used MySQL, Oracle, or SQL Server for the old product, do the following:
a. Go to the new_Software AG_directory/{Presto|MashZoneNG}/apache-tomcat/webapps/mashzone/WEB-INF/lib directory and delete the jackbe-presto-rds-postgre-derby-10.1.jar file.
b. Go to the new_Software AG_directory/{Presto|MashZoneNG}/prestorepository directory and copy the jackbe-presto-rds-oracle-mysql-mssql-10.1.jar file to the new_Software AG_directory/MashZoneNG/apache-tomcat/webapps/mashzone/WEB-INF/lib directory.
3. Configure the new MashZone NextGen to use the existing repository. For instructions, see MashZone NextGen Administration Guide, and then see the section on getting started with MashZone NextGen, and then see the section on moving the MashZone NextGen repositories to a robust database solution. Skip steps 1 through 4, and start with step 5.
Note:  
In MashZone NextGen 10.0 and earlier, repository connection information was defined in the apache-tomee-jaxrs/conf/tomee.xml file. In MashZone NextGen 10.1, repository connection information was moved to the apache-tomcat/conf/context.xml file and the format has changed.
4. Execute database update SQL commands for 10.1. Use a SQL client that is connected to your mashzonenextgenrepository. If you need help, contact Software AG Global Support.
a. Go to the new_SoftwareAG_directory/MashZoneNG/upgrade/10.1 directory and open the appropriate database_type.xml file in a text editor.
b. Read the instructions in the file and modify SQL statements that remove existing constraints as necessary.
c. Execute the SQL statements in the file one by one.
Copyright © 2007-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback