Filter
Top Products
6320ax02.fm Draft Document for Review July 28, 2004 7:33 pm
264 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
-- CREATE NEW MASTER CATALOGUE
insert into catalog values (10002,-2000,'Master Catalog','Master Catalog');
insert into catalogdsc values (10002,-1,'Master Catalog',NULL,NULL,NULL,NULL);
insert into catgroup values ((select max(catgroup_id) from catgroup)+1,-2000,'Master
Category',0,NULL,NULL,NULL,NULL);
insert into catgrpdesc (catgroup_id,language_id,name,published,shortdescription) values((select
max(catgroup_id) from catgroup),-1,'Master Category',1,'Master Category description');
insert into cattogrp values (10002,(select max(catgroup_id) from catgroup));
insert into storecat values (10001,10001);
insert into storecat values (10002,10001);
insert into storecgrp values (10001,(select max(catgroup_id) from catgroup));
-- ADD ALL CATENTRIES INTO ABOVE CATGROUP
insert into catgpenrel(catgroup_id, catalog_id, catentry_id, rule, sequence) select (select
max(catgroup_id) from catgroup), 10002, catentry_id, '-', 0.0 from catentry where catentry_id
<> 0;
-- UPDATE KEYS FOR CATALOG,CATGROUP
update keys set counter=(select max(counter) from keys where tablename='catalog')+1 where
tablename='catalog';
update keys set counter=(select max(counter) from keys where tablename='catgroup')+1 where
tablename='catgroup';
Database migration batch script
The script migration.bat migrated the database. This script takes the following
parameters:
1. Database name
2. DB user id
3. DB password
4. Log directory
5. Instance name
The script has the following behavior:
1. Set parameters as local variables
2. Call WebSphere Commerce V5.6s config_env.bat to set environment
variables
3. Call pre.migration.bat to prepare the database