We are upgrading our env to 8.4 version and we are using a database of mssql version 2014 and to compatible we are going to mssql 2019 version, how to restore the back up data from old server, is it a straightforward copy the bak file and copying in new server and perform restore or any other process involved?
@lsaipriya26 From IIQ standpoint, there is no specific guidelines. However you should coordinate with DB team who can help you with all necessary backups, SIDs review, restoration, DB scripts, Jobs, etc. These are DB specific steps which DBA should be aware of.
You can coordinate with them to come up with an action plan. If you want additional confirmation, you can also engage Sailpoint Support team to review the plan and provide suggestions.
Also, even though there should not be any impact on IIQ data, I would recommend capturing few stats before and after, like table sizing and total rows, and compare it after the upgrade.
Note: Found a fix?Help the community by marking the comment as solution. Feel free to react(
,
, etc.)with an emoji to show your appreciation or message me directly if your problem requires a deeper dive.
Normally we don’t do both upgrade at same time due to risk and complexity. first upgrade MSSQL then upgrade IIQ. in that case you will have less errors and it should be smooth upgrade.
here are some links
Restore a Database Backup Using SSMS - SQL Server | Microsoft Learn
Upgrading SQL Server databases and changing compatibility levels
if you are on 8.3 then Documentation says 8.3 supports MS SQL Server 2019 and 2017 for database.
@lsaipriya26 For this work, you should coordinate with your Database Administrator. DBA will guide you to properly migrate data.
Hi Saipriya,
This sql server upgrade activity should be led by the dba team, as they have to do almost all of the work.
As a sailpoint team, what you have to make sure is
-Verify SailPoint IIQ 8.4 supports SQL Server 2019
(Check SailPoint compatibility matrix → YES)
-Confirm DBA has valid .BAK backup file from SQL 2014
-Post-restore: Validate SailPoint application.
@lsaipriya26 Please let us know if you have any further queries on which we can help you out. If all looks good, please mark your post as resolved. This’ll help other Sailors having similar query. 
1 Like
Thanks for the suggestions , we had connected with DBA team and yes issue is resolved