6320ch_DEV_migration.fm Draft Document for Review July 28, 2004 7:33 pm
116 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
7.4 Migrating the development database
This section details how to migrate your development database. It is assumed
that you have already upgraded DB2 Universal Database V7.2.5 to DB2
Universal Database V8.1 on your development system as detailed in 5.5,
“Installing DB2 Universal Database V8.1” on page 77. This section explains how
to update your existing database so that it can be used in DB2 Universal
Database V8.1 and how to migrate it to the new schema for WebSphere
Commerce V5.6.
7.4.1 Migrating unencrypted data
This section details the steps that should be taken to migrate your existing
development database from WebSphere Commerce Suite V5.1 to WebSphere
Commerce V5.6.
To perform the migration, complete the following steps:
1. Open a DB2 Command Window if one is not already open.
2. Navigate to the following directory:
<wctookit_home>\bin
3. Run the migration script as follows:
migratedb -dbtype db2 -dbname database_name -dbuser user -dbpass pass
-from 51 -instance instancename -schema schema
where
– database_name is the name of your development database
– user is the user name for your database
– pass is the associated password
– instancename is the name of your instance
– schema is the schema name for your WebSphere Commerce tables,
which is usually the same as the database user name
Note: At this point the WebSphere Test Environment inside WebSphere
Studio Application Developer V5.1.1 has been updated and your custom
commands and data beans have been imported into WebSphere Studio
Application Developer.
The development environment is not completely migrated until the migration
steps in the following section are completed.