Filter
Top Products
6320ax02.fm Draft Document for Review July 28, 2004 7:33 pm
256 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
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>