RSA IGL 7.2 Data Migration

[MekalaSubramani]

Has any one migrated data from IGL 7.1.1 to IGL 7.2? Is there any special scripts to be executed?

[PradeepKadambar · Accepted solution]

Yes, there is a known issue with migration and the Before You Upgrade section in the release notes (RSA Identity Governance and Lifecycle 7.2.0.x Release Notes ) has 2 lines of SQL that needs to be run before running the migration.

Everything else is as documented in the RSA Identity Governance and Lifecycle 7.2 Upgrade and Migration Guide  for your deployment option.

[MekalaSubramani]

Thanks much Pradeep, Our migration is New Deployment (parallel environment) and migrating the data from 7.1.1. So going to try following steps 

 - Take IGL 7.1.1 backup
- Import 7.1.1 in IGL 7.2 enviornment

- Connect via SQL navigator and Run these queries

TRUNCATE TABLE T_AV_RULE_TEST_METRICS DROP ALL STORAGE;
TRUNCATE TABLE T_AV_RULE_TEST_VIOLS DROP ALL STORAGE;

- Start migration.sh

Hope this works

[PradeepKadambar]

Yes, these steps looks accurate.

I have to admit that I have done in place upgrade but these steps should be similar.

Please share your experience after the upgrade.

[MekalaSubramani]

This worked... Thanks Pradeep.

[MekalaSubramani]

UI based migration looks cool than command. But both gives good results.

[MekalaSubramani]

This worked... UI based migration is very easy.