Migrating HCL Commerce Version 9.1 databases
This document provides step-by-step instructions for migrating Commerce+
databases (DB2 or Oracle) from version 9.1.x.0 to HCL Commerce+ using the
wcim_ant utility. It includes guidance
for Development, Staging, and Production database environments.
Pre-requisite
Before you migrate to HCL Commerce+ 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 Commerce+ version 9.1.20.0 or higher. The migration process supports migrating to HCL Commerce+ 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 Verbosefor allwcim_antexecutions. 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
-
- Back up the 9.1.x.0 database and restore it to the HCL Commerce+ database environment.
- Run pre-migration checks using the wcim_ant tool.
- Perform the database migration using wcim_ant.
- Update the SITE table version.
- Run the updatedb utility from the HCL Commerce+ environment.