Babelfish for PostgreSQL documentation
This site contains the technical documentation for Babelfish for PostgreSQL, an Apache 2.0 and PostgreSQL open source project that adds a Microsoft SQL Server-compatible end-point to PostgreSQL. It will enable your PostgreSQL database to understand the SQL Server wire protocol and commonly used SQL Server commands. With Babelfish, 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 PostgreSQL with fewer code changes and without changing database drivers.
Why use Babelfish for PostgreSQL?
Babelfish for PostgreSQL is well-suited to the following use cases:
- Smooth transition of your Microsoft SQL Server compatible source code to an Open Source based database.
- Transitioning legacy applications where the source code is not available
Babelfish for PostgreSQL intends to move forward on its integration into the PostgreSQL community.
| Component | Purpose |
|---|---|
| Babelfish Patch | Enables Babelfish hooks for PostgreSQL. |
| Babelfish TDS Extension | TDS - provides a secondary endpoint that speaks the TDS (SQL Server) network protocol. |
| Balbelfish Language Extension | Provides a procedural language compatible with TSQL Uses ANTLR parser. |
| Babelfish Money Type | Supports the money type in Microsoft SQL Server. This is a variation of the opensource fixeddecimal extension. |
| Babelfish Common | Supports the various datatypes in Microsoft SQL Server. |
For specifics around the project, see the FAQ.
Get involved
Babelfish is supported by Amazon Web Services. All components are available under the Apache License, Version 2.0 and the PostgreSQL License on GitHub.
The project welcomes GitHub issues, bug fixes, features, plugins, documentation—anything at all. To get involved, see Contributing on the Babelfish for PostgreSQL website.