IBM SG24-6320-00 manual Migrating the development database, Migrating unencrypted data

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

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.

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

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