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
- Log on as the WebSphere Commerce non-root user.
-
Go to the following directory:
- WC_installdir\bin
-
Run one of the following commands:
config_ant.bat -buildfile WC_installdir/migration/xml/updateSiteTable.xml updateSiteRT -DinstanceName instanceName -DdbUserName dbUserName -DdbUserPassword dbUserPassword -DdbName dbName
config_ant.sh -buildfile WC_installdir/migration/xml/updateSiteTable.xml updateSiteRT -DinstanceName instanceName -DdbUserName dbUserName -DdbUserPassword dbUserPassword -DdbName dbName
config_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:
hostname:port/database name
hostname:port:database name
-
After the command completes, review of the following log to ensure that the command ran
successfully:
- WC_installdir\bin\updateServerSiteTable.log