Differences between Babelfish and SQL Server
In this section you can find information about functional differences between PostgreSQL with Babelfish and SQL Server. The information is organized into tables outlining SQL command support (based on the Compass configuration file) and updated by version of Babelfish you are using, and individual pages for non-SQL functionalities.
To efficiently identify the commands and feature options that are not supported by your target version of Babelfish, we recommend you start by running the Compass utility. After applying any updates to your application, test your application; if you encounter errors, consult the following pages for more information.
To review a list of SQL Commands that are not supported for your version, choose from the following reports:
To review a list of supported and unsupported non-SQL features, visit the page for the feature type:
- Built-in functions
- Error Code Mappings
- SET Statements
- Stored Procedures
- System Catalog Views
- System Functions
- PostgreSQL Extensions
Please note that this may not be a complete list of the functional differences between SQL Server and Babelfish. If you find syntax variations that should be included in the documentation, please file an issue to let us know about it.