Just for other people and Flexera as a hint,
trying to update FNMS on Prem 2022R2 to 2023R1 db migration on FNMSInventory run into an error for me:
...Running 'im-migr1920-migpost.sql...
There was an error while attempting to run 'im-migr1920-migpost...