IBM SG24-6320-00 Manuel D’Utilisation

6320ax02.fm

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

266

Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide

3. Apply patch for migrateencryptedinfo.bat into Utilities.jar, refer to

4. Call WebSphere Commerce V5.6 encrypted data migration script

migrateencryptedinfo.bat to migrate the encrypted data

5. Execute choosemc.sql to assign the master catalog

Database post migration SQL script

The SQL file executes the final changes needed on the database to finish the
database migration.

The post.migration.sql file will perform the following tasks:

1. Correct the index errors introduced by migratedb.bat

2. Remove records with non-encrypted values starting with space. Refer to

The content of the post.migration.sql file:

Example: C-5 Content of post.migration.sql file

-- CORRECT INDEX ERRORS DURING DB MIGRATION
create index I0000511 on campaign ( storeent_id asc);

drop index I0000539;
create index I0000539 on contract ( member_id asc);

create index I0000588 on initiative ( storeent_id asc);

drop index I0000824;
create index I0000824 on userpvcdev ( users_id asc);

-- DELETE ORDPAYINFO VALUES THAT STARTS WITH ' ' SO IT IS NOT ASSUMED TO BE A ENCRYPTED VALUE
delete from ordpayinfo where value like ' %';