Preparing the WebSphere Commerce Developer environment

Before beginning the first phase of migration, you need to ensure that the WebSphere Commerce Developer environment is ready for migration.

Procedure

  1. On your restored database, ensure that the data in your KEYS table is valid. In particular, ensure that any rows you have added for custom tables have valid data.
  2. Free enough disk space on your system to accommodate a backup of the WebSphere Commerce Developer Version 5.6.1 or 6.0 database.
  3. In the restored database, drop or disable custom constraints. The following table summarizes the customization actions that are recommended for your customization, depending on the table you have customized:
    WebSphere Commerce Developer tables recreated during migration Other WebSphere Commerce Developer tables Custom tables
    Foreign key A A A
    Index B D A
    Triggers, Procedure, View, Summary table, Function, and Methods C E E
    Where:
    A
    WebSphere Commerce Developer can migrate this customization. Leave the customization object as-is.
    B
    • DB2WebSphere Commerce Developer can migrate this customization. Leave the customization as-is.
    • For IBM i OS operating systemOracleYou need to reapply this customization after migration.
    C
    You need to reapply this customization after migration. The migration script does not migrate it, because JDBC has no corresponding API.
    D
    If the index has been customized as per the ../../com.ibm.commerce.database.doc/refs/rdbnamingconventions.html, WebSphere Commerce Developer can migrate this customization – leave it as-is. Otherwise, you need to manually drop the custom index before migration and reapply this custom index after migration.
    E
    If the customization does not refer to default WebSphere Commerce Developer recreated tables, it can be migrated normally – leave it as-is. Otherwise, you need to drop the customization manually before database migration and reapply this customization after database migration.
    The following table lists the WebSphere Commerce tables that are recreated during migration:
    From WebSphere Commerce Developer Version 5.6.1 From WebSphere Commerce Developer Version 6.0
    BUSAUDIT, CACHEIVL, CATENCALCD, CATGPCALCD, EMLMSG, ICMREGDESC, ORDERS, ORGENTITY, PX_PROMOTION, REFKEYS, STOREENTDS BUSAUDIT, CATENTRYATTR, GEONDDS, INVCNF, STLOCATTR, STLOCDS
    CATENCALCD, CATGPCALCD, EMLMSG, ORGENTITY, REFKEYS CATENTRYATTR, GEONDDS, INVCNF, PPCBATCH, STLOCATTR, STLOCDS
    BUSAUDIT, CATENCALCD, CATGPCALCD, EMLMSG, ICMREGDESC, ORDERS, ORGENTITY, PX_PROMOTION, REFKEYS, STOREENTDS BUSAUDIT

    Any customized foreign key constraints that have been added to the WebSphere Commerce Developer environment are handled automatically by the migration script. The script drops these foreign key constraints at the beginning of the database tier migration. The foreign key constraints are added back at the end of the database tier migration.

    DB2Any customized indexes that have been added to the WebSphere Commerce Developer environment are handled automatically by the migration script. The script drops these customized indices at the beginning of the database tier migration and adds them back at the end of the database tier migration.

    • DB2Use the drop action for these custom constraints
    • OracleUse the drop or disable actions for these custom constraints
  4. Ensure that the contents of your Updating the WebSphere Commerce configuration file are identical between the following two files:
    • The master configuration that is managed by the Configuration Manager, instance_name.xml
    • The configuration file that is used at runtime, wc-server.xml.
    See the Updating the WebSphere Commerce configuration file topic for more information about these files.