SQL server upgrade from 2019 to 2022

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

SailPoint IIQ 8.4p2

Share all details about your problem, including any error messages you may have received.

We are upgrading IIQ database SQL server 2019 to SQL server 2022.

Note: we are not upgrading from the existing SQL server. It is completely a new server where SQL server 2022 is installed and the DB data is copied from old database (2019) to new server (2022).
To achieve this, we stop our SailPoint application server and point to the new server where 2022 is installed and start the app server.

Now in case we notice any issue after upgrade to SQL server 2022 on PROD env, is there any way to copy the incremental data from new DB server to old DB server.

Did anyone face any such issue anytime ?

Thanks & Regards,

Milina Phalke

2

@milinaphalke What is the issue you are facing in PROD after switching your DB from old server to new server.

is there any way to copy the incremental data from new DB server to old DB server?

For the above question, you can check with your DB team if there is a recommended approach of doing this.

3

Hi Manish,

We have just upgraded the lower env, not yet done on PROD. So wanted to just check with team if anyone had faced any issue which we should take care about.

Currently in QA we are facing slowness. For this we will report to Database team.

Thanks & Regards,

Milina Phalke

4

@milinaphalke AFAIK backward incremental update is not possible. If you run on SQL 2022 for five hours and then decide to roll back to SQL 2019, any identities created, passwords changed, or access requests approved in those five hours stay in the 2022 DB.

But please check with your DBA if it is possible to ship Transactions logs from the 2022 instance back to the 2019 instance. They can help you better.

Note: Found a fix?Help the community by marking the comment as solution. Feel free to react(:heart:,:+1:, etc.)with an emoji to show your appreciation or message me directly if your problem requires a deeper dive.