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