How to Run Microsoft SQL Server applications on PostgreSQL with little to no code change ?

Many existing applications are built on legacy databases, and customers have had to deal with old-guard database providers that are expensive, proprietary, have high lock-in, impose punitive licensing terms, and perform frequent audits - This is why many organizations migrate from legacy databases to open source databases.

In fact, open source databases like MySQL, PostgreSQL, MongoDB, and Redis all rank among the world’s most popular databases. Fast-growing companies and large enterprises alike prefer open source databases due to their low cost, freedom from traditional license models, flexibility, community-backed development and support, and large ecosystems of tools and extensions.

While open source databases are widely available, they can become difficult and time-consuming to manage in production environments.

But. Migrating from legacy SQL Server databases can be time-consuming and resource-intensive. When migrating your databases, you can automate the migration of your database schema and data using the AWS Database Migration Service (DMS), but there is often more work to do to migrate the application itself, including re-writing application code that interacts with the database.

With Babelfish, Aurora PostgreSQL now understands T-SQL, Microsoft SQL Server's proprietary SQL dialect, and supports the same communications protocol, so your apps that were originally written for SQL Server can now work with Aurora with fewer code changes. As a result, the effort required to modify and move applications running on SQL Server 2005 or newer to Aurora is reduced, leading to faster, lower-risk, and more cost-effective migrations.

Babelfish is a built-in capability of Amazon Aurora, and does not have an additional cost. You can enable Babelfish on your Amazon Aurora cluster with a just few clicks in the RDS management console.

You are welcome to see a super interesting Case Study about real-world Microsoft SQL Server database modernization projects, best practices, risk mitigation techniques & how to successfully deliver a Babelfish app modernization project.

https://www.youtube.com/watch?v=HWljwZYsjvw

Enjoy!