How to migrate Production / Stage Endeca App to Local Environemnt ?

Data Migration Needs

As per ATG-Endeca Integration, All product catalog data gets stored in Endeca CAS record store during baseline process. Sometimes, these data needs to be migrated from Production to UAT or UAT to Dev.

APPLIES TO

Oracle Commerce Platform - Version 10.2 and later
Information in this document applies to any platform.

Solution

Export Data from Environment - Production

1. Identify record store names to be migrated.

Navigate to CAS Installation directory and list the record stores

/CAS/<>/bin->./component-manager-cmd.sh list-components

CRS_en_dimvals

CRS_en_data

CRS_en_schema

2. Identify if there are any active-transactions or not

/CAS/<>/bin->

./recordstore-cmd.sh list-active-transactions -a CRS_en_dimvals

./recordstore-cmd.sh list-active-transactions -a CRS_en_data

./recordstore-cmd.sh list-active-transactions -a CRS_en_schema

3. Fetch the current record store configuration

/CAS/<>/bin->

./recordstore-cmd.sh get-configuration -a CRS_en_dimvals -f CRS_en_dimvals.xml

./recordstore-cmd.sh get-configuration -a CRS_en_data -f CRS_en_data.xml

./recordstore-cmd.sh get-configuration -a CRS_en_schema -f CRS_en_schema.xml

4. Read data from record store and write into XML files

/CAS/<>/bin-> 

./recordstore-cmd.sh read-baseline -a CRS_en_dimvals -f data_CRS_en_dimvals.xml

./recordstore-cmd.sh read-baseline -a CRS_en_schema -f data_CRS_en_schema.xml

./recordstore-cmd.sh read-baseline -a CRS_en_data -f data_CRS_en_data.xml

Import Data with schema to enviornment -UAT

1. Set the CAS record Store Configuration using step 3 during import process

/CAS/<>/bin-> 

recordstore-cmd.bat set-configuration -a CRS_en_dimvals -f CRS_en_dimvals.xml

recordstore-cmd.bat set-configuration -a CRS_en_schema -f CRS_en_schema.xml

recordstore-cmd.bat set-configuration -a CRS_en_data -f CRS_en_data.xml

2. Use step 4 data and write record into record store 

/CAS/<>/bin-> 

recordstore-cmd.bat write -a CRS_en_dimvals -f data_CRS_en_dimvals.xml

recordstore-cmd.bat write -a CRS_en_schema -f data_CRS_en_schema.xml

recordstore-cmd.bat write -a CRS_en_data -f data_CRS_en_data.xml

Note :- CRS_en_schema is not used for CAS based Indexing after 11.1 version.