IBM SG24-6320-00 manual WebSphere Commerce V5.6 migration scripts behavior, Migratedb.bat behavior

6320ax02.fm Draft Document for Review July 28, 2004 7:33 pm

WebSphere Commerce V5.6 migration scripts behavior

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.

migratedb.bat behavior

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:

Example: C-1 Excerpt of DataMigrationPlan51.xml 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>

256Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide