Transaction data migration

You can migrate your transaction data between releases using the command line.

After you upgrade to Sterling™ Order Management System Software, Release 10.0, install Sterling Store Engagement (Legacy), Release 10.0.

To migrate the upgrade-transaction-tables data from Release 9.3, 9.4, or 9.5 to Release 10.0, run the following command from the <INSTALL_DIR>/Migration/9.5/wsc directory:

Running the following command performs the following tasks:
${ANT_HOME}/bin/ant -f wscmigration.xml -Druntime=<INSTALL_DIR> -Druntime.old=<INSTALL_DIR_OLD> 
-Dtarget=upgrade-transaction-tables migrate -logfile <logfile>
  • Performs the apply-fc-setup and -update-si-version tasks.
  • The following *.done files are created in the status folder for the upgrade-transaction-tables task:
    • transaction_ant_applyfcsetup.xml.done
    • wsc_transaction_ant_applicationversion.xml.done
    Note: As part of the transaction data migration, only the factory defaults are upgraded.

After the tasks are completed, search for all the *.restart files under the <INSTALL_DIR>/Migration/9.5/wsc/database/FactorySetup/XMLS directory.

To ensure that the upgrade is successfully completed , the value of the Completed attribute in the *.restart files under the <INSTALL_DIR>/Migration/9.5/wsc/database/FactorySetup/XMLS directory should be set to Y for all the tasks.
  • If the value of the Completed attribute is set to N contact IBM Technical Support for assistance.
    Note: The transaction data migration is not performed in the activator mode. Therefore, the event, the event handlers and the pipeline conditions are not overridden.
  • If you want to clear or remove all *.restart and *.done files before restarting the transaction data migration, run the following command: 
    ${ANT_HOME}/bin/ant -f wscmigration.xml -Druntime=<INSTALL_DIR> -Druntime.old=<INSTALL_DIR_OLD> 
-Dtarget=clean-up-for-rerun migrate -logfile <logfile>