Run a java migration from 4.5 to 5.0

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:
cd Wizards
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:

For DB2
For Oracle
For SQL Server