+

Search Tips   |   Advanced Search

Run a java migration from 4.5 to 5.0

When migrating the Connections Homepage database schema from 4.5 to 5.0, we must run a java migration.


For DB2

    For AIX or Linux:

    cd Wizards 
    jvm/OS/jre/bin/java -Dfile.encoding=UTF-8 \
                        -Xmx1024m \
                        -classpath /path/to/db2jcc.jar:/path/to/db2jcc_license_cu.jar:lib/lc.dbmigration.default.jar:lib/commons-logging-1.0.4.jar:lib/news.common.jar:lib/news.migrate.jar \
                        com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
                        -dburl jdbc:db2://dbHost:dbPort/HOMEPAGE
                        -dbuser dbUser \
                        -dbpassword dbPassword > java.out.log 2>&1
    

    where:

    • /path/to is the location of your JDBC driver.
    • dbHost is the name of the system hosting the database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.

    For Windows:

      jvm\win\jre\bin\java -Dfile.encoding=UTF-8 -Xmx1024m -classpath /path/to\db2jcc.jar;/path/to\db2jcc_license_cu.jar;lib\lc.dbmigration.default.jar;lib\commons-logging-1.0.4.jar;lib\news.common.jar:lib\news.migrate.jar com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50 -dburl jdbc:db2://dbHost:dbPort/HOMEPAGE -dbuser dbUser -dbpassword dbPassword > java.out.log 2>&1


For Oracle

To run the java migration:

    For AIX or Linux:

    cd Wizards 
    java -Dfile.encoding=UTF-8 \
         -Xmx1024m \
         -classpath lib/ojdbc6.jar;lib/lc.dbmigration.default.jar;lib/commons-logging-1.0.4.jar;lib/news.common.jar;lib/news.migrate.jar \
         com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50 \
         -dburl jdbc:oracle:thin:@<dbHost>:<dbPort>:<dbInstance> 
         -dbuser dbUser 
         -dbpassword dbPassword > java.out.log 2>&1
    

    For Windows:

      jvm\win\jre\bin\java -Dfile.encoding=UTF-8 -Xmx1024m -classpath /path/to\ojdbc6.jar;lib\lc.dbmigration.default.jar;lib\commons-logging-1.0.4.jar;lib\news.common.jar:lib\news.migrate.jar com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50 -dburl jdbc:oracle:thin:@//dbHost:dbPort/ServiceName | -dburl jdbc:oracle:thin:@dbHost:dbPort:SID -dbuser dbUser -dbpassword dbPassword > java.out.log 2>&1


For SQL Server

To run the java migration:

  1. cd Wizards

  2. Enter the following text as a command on a single line:

    For AIX or Linux:

    jvm\win\jre\bin\java -Dfile.encoding=UTF-8 -Xmx1024m -classpath
    /path/to\sqljdbc4.jar;
    lib\lc.dbmigration.default.jar;
    lib\commons-logging-1.0.4.jar;
    lib\news.common.jar;
    lib\news.migrate.jar 
    com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
    -dburl jdbc:sqlserver://dbHost:dbPort;databaseName=HOMEPAGE
    -dbuser dbUser -dbpassword dbPassword > java.out.log 2>&1

    where:

    • /path/to is the location of your JDBC driver.
    • dbHost is the name of the system hosting the database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.

    For Windows:

    jvm\win\jre\bin\java -Dfile.encoding=UTF-8 -Xmx1024m -classpath
    /path/to\db2jcc.jar;
    /path/to\db2jcc_license_cu.jar;
    lib\lc.dbmigration.default.jar;
    lib\commons-logging-1.0.4.jar;
    lib\news.common.jar:
    lib\news.migrate.jar 
    com.ibm.lconn.news.migration.next50.NewsMigrationFrom45To50
    -dburl jdbc:db2://dbHost:dbPort/HOMEPAGE
    -dbuser dbUser -dbpassword dbPassword > java.out.log 2>&1

    where:

    • /path/to is the location of your JDBC driver.
    • dbHost is the name of the system hosting the database.
    • dbPort is the communications port of the database.
    • dbUser is the database administrator ID.
    • dbPassword is the administrator password.


Parent topic:
Update 4.0 and 4.5 databases manually

Use the appropriate java migration command for the database type: