Migrating HCL Commerce Version 9.1 databases

Migrate HCL Commerce v9.1.x.0 databases (Db2 or Oracle) to HCL Commerce+ Transaction Server using the wcim_ant utility. It includes guidance for Development, Staging, and Production database environments.

Pre-requisite

Before you migrate to HCL Commerce+ Transaction Server from HCL Commerce Version 9.1, review this information to help plan and execute your migration.

To initiate the migration, ensure the customer environment is on HCL Commerce version 9.1.20.0 or higher. The migration process supports migrating to HCL Commerce+ Transaction Server version 26.07.22 (July 2026) and onward.

Best practices for Database migration
Backup everything first
Always complete the backup of the source database before starting migration. Retain backups until post-migration verification is complete.
Use a Non-Production Environment First
To uncover potential issues early, perform trial migrations in a development or staging environment.
Monitor Logs Closely
Use -logLevel Verbose for all wcim_ant executions. Review the logs immediately after each migration step for errors or warnings.
Set Maintenance Windows
Schedule the migration during a designated maintenance window to avoid disruption to business operations.
Post-Migration Validation
To confirm application stability, test core functionalities like storefront access, catalog browsing, order placement, and admin tools.
Update SITE Table Correctly
Ensure the SITE table version is correctly updated and audited as part of the migration checklist.
High-Level Migration Steps
  1. Back up the 9.1.x.0 database and restore it to the HCL Commerce+ Transaction Server database environment.
  2. Run pre-migration checks using the wcim_ant tool.
  3. Perform the database migration using wcim_ant.
  4. Update the SITE table version.
  5. Run the updatedb utility from the HCL Commerce+ Transaction Server environment.