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>