How do I migrate stored procedures with return status from SQL Server/Sybase to PostgreSQL
0
While migrating from SQL Server or Sybase database to PostgreSQL, how do you convert a stored procedure with return status and check if procedure call is successful.
Sample example: EXEC @return_status = sample_proc
asked 2 years ago9 views
1 Answers
0
Accepted Answer
If there is no need for transactional level commit or rollback statements, then you can opt to make it Function in PostgreSQL and Return Status code as per Execution logic. Function in PostgreSQL should suffice most of cases as compared to Procedure in commercial database engines.
answered 2 years ago
Relevant questions
Unable to refresh QuickSight Dataset
asked 3 months agoHow do I migrate stored procedures with return status from SQL Server/Sybase to PostgreSQL
Accepted Answerasked 2 years agoInvalid operation when creating Stored Procedure
asked 3 years agoProgrammatically Running a Stored Procedure in Redshift
asked 3 years agoMigrate snapshot option disabled
asked a year agoCall a stored procedure in Redshift from Glue
Accepted Answerasked 3 years agoHow to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.
asked 12 days agoRDS for SQL. List of supported system_procedures
asked 2 months agoTrigger stored procedure upon glue job succe
asked 4 months agoSend notification upon SQL failure
asked 4 months ago