Migration IBM initiate V9 to IBM MDM v11(Virtual) - Database

Migration IBM initiate V9 to IBM MDM v11(Virtual) - Database
 1.V11 have change 3 tables structure MPI_HANDALER,
 2.New MPI_HANDALER will be automatically populated at the time of Application Deployment using WAS
 3.Export all data/tables with help of DBA from V9  BD
 4.Run below script it will help u to restructure V11 table as per V9 DB(BEFORE DATA LOAD TO V11 SCRIPT)
 5.Import the data with help of DBA to V11 DB
 6.Run below script it will help u to revert back to DB structure  V11 (AFTER DATA LOAD SCRIPT)
 7.Now enjoy u r db migration V9 to V11

BEFORE DATA LOAD TO V11 SCRIPT
***********************************
ET ECHO ON
SET TIME ON
SET TIMING ON
SET FEEDBACK ON
SPOOL BeforeDataLoad.log;
ALTER TABLE MPI_MEMEMAIL DROP COLUMN FORMAT;
ALTER TABLE MPI_MEMEMAIL ADD OPTIN VARCHAR2(20);
ALTER TABLE MPI_MEMEMAIL ADD FORMAT VARCHAR2(1);
ALTER TABLE MPI_ENTIQUE_ORG DROP COLUMN WRKPRIOR;
spool off;

*******************************

AFTER DATA LOAD SCRIPT FOR V11
*************************
SET ECHO ON
SET TIME ON
SET TIMING ON
SET FEEDBACK ON
SPOOL AfterDataLoad.log;
ALTER TABLE MPI_MEMEMAIL DROP COLUMN OPTIN;
ALTER TABLE MPI_ENTIQUE_ORG ADD WRKPRIOR NUMBER(5,0);
UPDATE MPI_ENTIQUE_ORG SET WRKPRIOR=0;
COMMIT;
ALTER TABLE MPI_ENTIQUE_ORG MODIFY WRKPRIOR NUMBER(5,0) NOT NULL;
spool off;

********************************************