Re: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example

2022-08-14 Thread hector vass
I would suggest no easy way with a tool .. postgresql is powerful because you can write functions in different languages in addition to PLpgSQL so python,perl,tcl,js,c++ and there are many popular extensions. So very possible to encapsulate complex application/business logic within database. But

RE: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example

2022-08-12 Thread Joel Rabinovitch
Hi, When we did our migration from SQL Server to PostgreSQL, we mainly used two tools: sqlserver2pgsql for most of our schema-related changes. You can find that here: https://github.com/dalibo/sqlserver2pgsql. AWS Schema Conversion Tool (SCT) for migrating views and stored