There is a method of simulating SQL Server by using PostgreSQL. The extension is called "Babelfish": https://babelfishpg.org/However, this extension requires modifications to the PostgreSQL source and building the PostgreSQL with Babelfish modifications from source. While it is a rather seamless process and goes on without much trouble, it is still much more complicated than installing the RPM or DEB packages, depending on your Linux distro of choice. Is there any chance that the Babelfish modifications will be adopted in the PostgreSQL source proper? From my DBA point of view, I didn't find any differences in the functionality of the PostgreSQL database itself. Amazon RDS incorporates that modification and allows creating Aurora PostgreSQL database with the Babelfish extension from the menu.
Hi there, I'm currently part of the Babelfish Open Source team.
Regarding the installation process it works, but is far from being smooth or ready to get OS packages
(there is, although, an ongoing work to get Docker images support in the upcoming months).
But most importantly, we won't see this into core anytime soon -- or maybe, we just won't see it as it is.
There is a patch for supporting protocol extensibility, but that requires considerable rework on the Babelfish
tds and tsql extensions if moving forward.
There is a long thread discussing about this in the pgsql-hackers list: https://www.postgresql.org/message-id/flat/CAGBW59d5SjLyJLt-jwNv%2BoP6esbD8SCB%3D%3D%3D11WVe5%3DdOHLQ5wQ%40mail.gmail.com
Even though there is intensive work from the AWS team to support and build distributions for Babelfish, it is
still a great solution for migrating from SQL Server while keeping legacy applications working.
Regards,
--
Emanuel Calvo -- 3manuek.com
OnGres Data Engineer / ViaDB Founder
CanalDBA BDFL -- Sumate al Slack canaldba.com!
