Migrate > Take the first steps after WebSphere Commerce migration



Reuse custom staging triggers

If you created custom tables with staging triggers in a previous version of WebSphere Commerce, you can continue to use the custom triggers. Run the provided scripts to allow the unchanged custom triggers to continue to use the KEYS table to maintain the primary key values of the STAGLOG table.

Alternatively, you can update the existing staging triggers for better performance and scalability. For an example of how to update the trigger, see Stage trigger example.


Procedure

  1. Connect to the staging database.

    • DB2 db2 connect to stagingdbuser db_user using db_password

    • Oracle sqlplus db_user/db_password@stagingdb

  2. Run the following script:

    • DB2 db2 -td# -vf WC_INSTALL/schema/db2/wcs.stage.heteroTriggerSupport.sql

    • Oracle sqlplus @WC_INSTALL/schema/oracle/wcs.stage.heteroTriggerSupport.sql


Related concepts

Performance enhancements

Stage server


+

Search Tips   |   Advanced Search