Re: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example

Поиск
Список
Период
Сортировка
От hector vass
Тема Re: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example
Дата
Msg-id CAJJx+iWe3XX2NpHpOpDm0+ap-3spsQ0dz4g_ZneChD6EMi+YZw@mail.gmail.com
обсуждение исходный текст
Ответ на Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example  (Scott Simpson <Scott.Simpson@zellis.com>)
Список pgsql-general
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.Simpson@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.Simpson@Zellis.com

Web : 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.
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: howardnews@selestial.com
Дата:
Сообщение: Re: Could not load server certificate file "server.crt": No such file or directory.
Следующее
От: FOUTE K. Jaurès
Дата:
Сообщение: ERROR: savepoint "jdbc_savepoint_532" does not exist