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 if it is just a database with a bit of PLpgSQL to expose data to a front end application that does all the work then maybe a tool might work. You may have noticed how powerful AWS SCT is converting MSSQL & Oracle to Postgresql but alas will I believe only convert Postgresql to Postres alike databases Aurora and MySQL ... Not to say someone somewhere hasn’t but a claimed strength of Postgresql is probably a hindrance in this instance.
Hector Vass Data Engineer 07773 352559 On Fri, 12 Aug 2022, 11:24 Scott Simpson, <scott.simp...@zellis.com> wrote: > Hi, > > I need to migrate many PostgreSQL Stored Procedures and functions to MSSQL. > > I can find anything online that seems to handle this task. > > Are there any tools that you have that can do this job? > > > *Kind Regards* > > > *Zellis* | Scott Simpson | Senior Engineer > > > > Thorpe Park > > United Kingdom > > Work : +44 (0)20 3986 3523 > > Email : scott.simp...@zellis.com <daniel.mu...@zellis.com> > > Web : www.Zellis.com <http://www.zellis.com/> > > > ------------------------------ > > *Zellis is the trading name for Zellis Holdings Ltd and its associated > companies “Zellis”.* > > The contents of this email are confidential to Zellis and are solely for > the use of the intended recipient. If you received this email in error, > please inform the sender immediately and delete the email from your system. > Unless Zellis have given you express permission to do so, please do not > disclose, distribute or copy the contents of this email. > > Unless this email expressly states that it is a contractual offer or > acceptance, it is not sent with the intention of creating a legal > relationship and does not constitute an offer or acceptance which could > give rise to a contract. > > Any views expressed in this email are those of the individual sender > unless the email specifically states them to be the views of Zellis. > > Zellis Holdings Ltd - registered in England and Wales - Company No: > 10975623 - Registered Office: 740 Waterside Drive, Aztec West, Almondsbury, > Bristol, BS32 4UF, UK. >
