IBM SG24-6320-00 Manuale Utente

Draft Document for Review July 28, 2004 7:33 pm

Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide

This section discusses the specific execution behaviors of the various migration 
scripts. This information would be useful for the advanced users who have gone 
through various test-runs of migration and are concerned about performance 
tuning the database for quicker migration by understanding the underlying 
execution behavior of these scripts. If you modify the migration scripts it could 
potentially result in unsupported migration.

This script migrates the database schema and the unencrypted data as needed. 
The behavior of this script is controlled by one or other configuration file 
depending on your pre-migration WebSphere Commerce level.

In our case the relevant configuration file would be:

WC56_install_dir/schema/migration/config/DataMigrationPlan51.xml

Here is an excerpt of the configuration file:

<dataMigrationCommand name="drop.wcs.constraint" type="sql">
       <command>
            wcs.drop.referential.sql,
            wcs.drop.view.sql,
            wcs.drop.key.sql,
            wcs.drop.index.sql
       </command>
    </dataMigrationCommand>
<dataMigrationCommand name="backup.wcs.bootstrap" type="sql">
       <command>
            wcs.backup.bootstrap.sql,
            wcs.delete.bootstrap.sql,
            wcs.delete.bootstrap_en_US.sql
       </command>
    </dataMigrationCommand>
<dataMigrationCommand name="apply.wcs.schema.delta" type="sql">
      <command>
wcs.fix.null.notnull.sql,
wcs.schema.new.tables.sql,
wcs.schema.recreate.tables.sql,
wcs.schema.alter.tables.sql
      </command>
      <property name="commitCount" value="1" />
    </dataMigrationCommand>