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. With the addition of Babelfish, PostgreSQL understands T-SQL, SQL Server’s proprietary SQL dialect, and supports the TDS communication protocol, so applications originally written for SQL Server may work with PostgreSQL with fewer code changes and without changing database drivers.
Why use Babelfish for PostgreSQL?
Babelfish for PostgreSQL may help in the following use cases:
- When transitioning your SQL Server compatible source code to an open-source based database.
- When moving away from proprietary or legacy applications that don’t make source code available.
Babelfish for PostgreSQL functionality is distributed in five components:
|Babelfish Server Patch||Enables Babelfish hooks for PostgreSQL.|
|Babelfish TDS Extension||TDS - provides a secondary endpoint that speaks the TDS (SQL Server) network protocol.|
|Babelfish Language Extension||Provides a procedural language compatible with T-SQL (Uses ANTLR parser).|
|Babelfish Money Type||Supports the money type in SQL Server. This is a variation of the open-source fixed-decimal extension.|
|Babelfish Common||Supports the various datatypes in SQL Server.|
For information about the project components, see the Software architecture page.
The project welcomes your contributions and feedback on issues, bug fixes, features, plugins, and documentation. To get involved, visit the Babelfish for PostgreSQL website.