My customer is currently using Microsoft SQL server 2019 (RTM-CU32-GDR) database with OPA 25.1 HF17 and they are asking for guidance about the impact of changing a datatype.
They have a web service building block on their entity and they experiencing an issue.
They have an "ID" input parameter that is currently defined as an INT, but there are now IDs that exceed the maximum INT value, causing the service to fail.
Question:
If the parameter is changed (for example to BIGINT), what is the impact on the performance of the service, the platform, and on existing cases that have already been created?
Do you have any experience with this?
