Posted On: Oct 28, 2021
Babelfish for Aurora PostgreSQL is a new capability for Amazon Aurora PostgreSQL-Compatible Edition that enables it to understand queries from applications written for Microsoft SQL Server. With Babelfish, applications currently running on SQL Server can run directly on Aurora PostgreSQL with a fraction of the work required, compared to a traditional migration. Babelfish understands the SQL Server wire-protocol (TDS) and T-SQL, the Microsoft SQL Server query language, so you don't have to switch database drivers or re-write all of your application queries.
You can connect to Babelfish by changing your SQL Server-based applications to point to the Babelfish TDS port on an Aurora PostgreSQL cluster, after turning Babelfish on. Babelfish includes support for stored procedures, savepoints, static cursors, nested transactions, the SQL_VARIANT data type and much more.
Babelfish for Amazon Aurora PostgreSQL is available in all regions supported by Aurora PostgreSQL, including AWS GovCloud (US) Regions.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Aurora product page. To get started with Aurora PostgreSQL-Compatible Edition, take a look at our getting started page. Or, to learn more about Babelfish, visit the Babelfish for Aurora PostgreSQL product page.