websss
asked on
Move from Sql Server to Postgres - Stored procedures?
We are currently using Sql Server as our database
We are now planning on moving to PostgreSql 12
Most things look ok, but we mainly use stored procedures in sql server to return data
I cannot find out how to migrate these from Sql Server to postgres
Does anyone have any ideas if this is possible or what the impact will be?
We are now planning on moving to PostgreSql 12
Most things look ok, but we mainly use stored procedures in sql server to return data
I cannot find out how to migrate these from Sql Server to postgres
Does anyone have any ideas if this is possible or what the impact will be?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks, we did look at MariaDB but went for Postgres in the end due to many reasons
To migrate from Microsoft SQL procedures to any other SQL server requires a manual, line by line audit + transposition of all stored procedure code.