Migrating from Earlier Versions : Migrating Data to a Current Backing Store Implementation

Migrating Data to a Current Backing Store Implementation
This section explains how to migrate data from an Oracle-only backing store to a newly created JDBC backing store or to an upgraded legacy Oracle-only backing store. As a result, the BusinessEvents engine can continue running under the new backing store, using historical data.
It is strongly recommended that you migrate to the JDBC backing store implementation. See Migrate the Backing Store Implementation and Backing Store Data for guidelines.
The process outlined here migrates the data from an Oracle-only backing store to a newly created JDBC backing store. You can also migrate data from an older Oracle-only backing store to a newer Oracle-only backing store, but that is a less common case.
You must keep the JDBC Connection resource for the existing Oracle-only backing store, and you must be able to connect to it.
The data migration process uses two backing stores. However after migration, you'll have one backing store. Use of two backing stores is limited to migration procedures.
 
Task A Set Up the Backing Store Database and Add a JDBC Connection
If you have not yet imported your 3.x project into BusinessEvents Studio, do so before you begin.
The first task is to set up a new backing store, including creation of a new JDBC Connection resource.
Do not remove the JDBC Connection resource for the Oracle-only backing store database from your project until you have completed all migration tasks.
When you have set up the new backing store, including the CDD settings, Rebuild the EAR file.
Task B Set Up the BusinessEvents TRA File
Open the BE_HOME/bin/be-migration.tra file and specify appropriate values for the properties shown below (with example values). Notes on the properties follow.

 
# Oracle/JDBC Migration Properties
be.migration.batchsize 1000
be.migration.workersize 16
be.migration.objecttable true
be.migration.target.type jdbc
 
# Database URLs
# Source database:
be.oracle.dburi.count 1
be.oracle.dburi.0 /Resources/myORCL.sharedjdbc
be.oracle.dburi.pool.initial.0 5
be.oracle.dburi.pool.min.0 5
be.oracle.dburi.pool.max.0 10
 
# Target database:
be.jdbc.dburi.count 1
be.jdbc.dburi.0 /Resources/myJDBC.sharedjdbc
be.jdbc.dburi.pool.initial.0 5
be.jdbc.dburi.pool.min.0 5
be.jdbc.dburi.pool.max.0 10

 
Task C Run the Data Migration Process
1.
Open a command prompt, navigate to BE_HOME/bin, and execute the following command:
   be-migration -copy -ear EARFile
Wait until the process is complete
2.
If you set the property be.migration.objecttable=false in Task B then you must manually migrate OBJECTTABLE table contents.
3.