The AWS schema Conversion Tool might be helpful for MS SQL Server
migrations to Postgres (
https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html)
It will at least help you determine level of effort and which objects might
need refactoring.
Best regards,
Dan Smith