We have a situation that Database and Infra team can only support building new Servers and Database. They are not in a state to upgrade the existing infra and Database.
We want to perform upgrade to the latest version and for that in order to align with SailPoint’ support matrix we need to have new version of Database and Linux servers.
Here are the 2 approaches we have identified:
Get new servers and DB and do a fresh installation of newer version then perform Data migration
Get new servers and DB and then copy the current db to new DB. Install the current version we are running and connect with DB. Then perform upgrade steps.
We would like to understand what is the recommended approach here and why?
Also wanted to check if SailPoint supports such an upgrade approach?
The way you have option 1 outline, it will not work. Yes you can create a new DB and run the latest IIQ DB scripts to create the tables and stuff but migrating your old/existing data into these tables will not work so well since the versions will be different and each major version of IIQ makes changes to the DB tables and the data in them.
For option 1 this is what you can do. Using your existing Server and DB, follow the upgrade path to upgrade IIQ and its DB to the latest. As you are going through the upgrade path, you may need to update like your tomcat version and stuff. Once IIQ is fully upgraded migrating the data to your new DB with the latest IIQ DB version should work.
I do have a question for you. what is the current IIQ version that you are using?