Migrating from APIM 1.3.0/1.3.1 to APIM 1.4.0

The steps below explain how to migrate from API Manager 1.3.1 to API Manager 1.4.0. Same instructions apply to migrate from APIM 1.3.0 to APIM 1.4.0 as well.

1. Shut down APIM 1.3.1 server if it is running.

2. Open <APIM 1.3.1_HOME>/repository/conf/carbon.xml file, uncomment the <H2DatabaseConfiguration> element and edit it as follows:

   <H2DatabaseConfiguration>
      <property name="web"/>
      <property name="webPort">8082</property>
      <property name="webAllowOthers"/>
   </H2DatabaseConfiguration>

3. Start APIM 1.3.1 server. Also Download and start APIM 1.4.0.

4. Go to <APIM 1.4.0_HOME>/dbscripts/migration-1.3.0_to_1.4.0 folder, select the preferred database script from the scripts available there and run it against the APIM 1.3.1 server. For example, if your database is H2, you must run h2.sql.
5. Go to APIM 1.3.1 management console (http://localhost:8082), open the H2 Web client and provide the H2 database URL of APIM 1.3.1 server as the JDBC URL (i.e., jdbc:h2:/home/data/wso2/wso2am-1.3.1/repository/database/WSO2AM_DB). Then, connect using wso2carbon/wso2carbon credentials.
6. Copy the contents of the database script you got in step 4 (e.g., h2.sql) in the provided text box and click run. 

7. Go to <APIM 1.4.0_HOME>/dbscripts/migration-1.3.0_to_1.4.0/api_comments_ratings_migration_client folder and run the migration client you find there by following the exact steps in the README file, also saved in the same folder.

   NOTE: When you configure the build.xml file, be sure to end the path of property registry.home with a "/". For example, /home/data/wso2/wso2am-1.3.1/.

8. If you are migrating the H2 database, you must manually copy the migrated database file. To do that, replace <APIM 1.3.1_HOME>/database/WSO2AM_DB.h2.db and <APIM 1.3.1_HOME>/database/WSO2CARBON_DB.h2.db files with <APIM 1.4.0_HOME>/database/WSO2AM_DB.h2.db file.
9. Replace <APIM 1.3.1_HOME>/repository/deployment/server/synapse-configs folder with <APIM 1.4.0_HOME>/repository/deployment/server/synapse-configs. This replaces old synapse configs with new ones.

10. You have now migrated the database.