Updating the SITE table on the migrated database

After you complete the database migration, the SITE table will still contain version 7.0 values. As a final step to the migration, update the SITE table to contain the required version 8.0 values by using the updateSiteRT ANT task.

Note: It is safe to run this ANT task to update a live production database.

Procedure

  1. Log on as the WebSphere Commerce non-root user.
  2. Go to the following directory:
    • WC_installdir\bin
  3. Run one of the following commands:
    • Windowsconfig_ant.bat -buildfile WC_installdir/migration/xml/updateSiteTable.xml updateSiteRT -DinstanceName instanceName -DdbUserName dbUserName -DdbUserPassword dbUserPassword -DdbName dbName
    • LinuxAIXconfig_ant.sh -buildfile WC_installdir/migration/xml/updateSiteTable.xml updateSiteRT -DinstanceName instanceName -DdbUserName dbUserName -DdbUserPassword dbUserPassword -DdbName dbName
    • For IBM i OS operating systemconfig_ant.sh -buildfile WC_installdir/migration/xml/updateSiteTable.xml updateSiteRT -DinstanceName instanceName -DdbUserName dbUserName -DdbUserPassword dbUserPassword -DdbName dbName
    instanceName
    The WebSphere Commerce instance name.
    dbUserName
    The database user name of the migrated database.
    dbUserPassword
    The database user password of the migrated database.
    dbName
    This parameter is only for remote databases and refers to the fully qualified host name, port, and database name of the migrated database, for example:
    • DB2hostname:port/database name
    • Oraclehostname:port:database name
  4. After the command completes, review of the following log to ensure that the command ran successfully:
    • WC_installdir\bin\updateServerSiteTable.log