Page Comparison

...

1. Disconnect all the subscribers and publishers for WSO2 MB 3.2.0.
2. Shut down the server.
3. If you are using an Oracle database, run the migration script to update the database:
   1. Open a terminal and navigate to the <MB_HOME>/dbscripts/mb-store/migration-3.1.0_to_3.2.0 directory.
   2. Execute the following command: 
      • On Windows: oracle-mb.sql
      • On Linux: sh oracle-mb.sql 
4. Download and run the migration tool:
   
   1. Download the migration tool.

   2. Unzip the org.wso2.mb.migration.tool.zip file. The directory structure of the unzipped folder is as follows:

      Panel
      TOOL_HOME |-- lib <folder> |-- config.properties <file> |-- tool.sh <file> |-- README.txt <file> |-- org.wso2.carbon.mb.migration.tool.jar

   3. Download the relevant database connector and copy it to the lib directory in the above folder structure. For example, if you are upgrading your MySQL databases, you can download the MySQL connector JAR from http://dev.mysql.com/downloads/connector/j/5.1.html and copy it to the lib directory.

   4. Open the config.properties file from the org.wso2.mb.migration.tool.zip file that you downloaded in step 4 above and update the database connection details shown below. 
      

      Code Block
      #Configurations for the database dburl= driverclassname= dbuser= dbpassword=

      The parameter in the above file are as follows:

      • dburl: The URL for the database. For example, jdbc:mysql://localhost/wso2_mb
      • driverclassname:The database driver class. For example, com.mysql.jdbc.Driver for MySQL.
      • dbuser: The user name for connecting to the database.
      • dbpassword: The password for connecting to the database.
   5. Update the datasource connection for the MB database in the master-datasources.xml file (stored in the <MB_HOME_320>/repository/conf/datasources directory).

   6. Run the migration tool:

      1. If you are on a Linux environment, open a command prompt and execute the following command: tool.sh.

      2. If you are on a non-Linux environment, execute org.wso2.carbon.mb.migration.tool.jar manually.
5. Start WSO2 MB 3.2.0.
6. Reconnect all the publishers and subscribers to MB 3.2.0.

...