Hello Everyone,

We're planning a major out-of-place upgrade from 7.1.9 to 24.1.

Infra -- Azure Cloud (client-managed), Linux Red Hat (OS), Java 17, MSSQL Server 2022

There's no FW in the application.

I have some questions about the approach and best practices, and I'd like expert advice.

1) For the lower environments (Dev, QA, UAT) upgrade, can we use Rules schema from Stage (because it's a stable code base) and use Data schema from the respective environments, so that each env can have different variety of test data for testing. Or both schemas should be from Stage env only?

2) Skimming should be done using Stage Rules schema only?

3) Skimmed RSVs should be deployed before executing the upgrade.sh scripts?

4) Can this new schema having skimmed RSVs and upgrade script already executed be treated as baseline for next env?

5) Can we restore/copy both Rules & Data schema using DB tools or we should create new schemas and then migrate using "migrate.sh" script? Will it make any difference?