What are the limitations of Babelfish?

Tip: Use the Babelfish Compass tool to generate a simple HTML report of Babelfish support for your application. All you need is a DDL export of your application, and the free Compass tool.

For the official list of differences between Babelfish and SQL Server, please see the main document below, which is extremely thorough, as well as the list of top items in this post.

Main document with differences between Babelfish and SQL Server

Top Items That Babelfish Does Not Support

Updated: June 2022, Babelfish 1.3.0. Please check back regularly; Babelfish frequently adds new capabilities.

• DDL export / "Script Database as.." for the TDS port is not yet fully supported (1.3.0). Ensure you save DDLs in an external file for later use.
• MARS, Database Mail, Geospatial, SQLCLR, Filetable, Columnstore
• Dependency on MSDTC OR SQL Server Agent
• Limited use case support with SSRS, SSIS, or SSAS (see AWS blogs for ways to use SSIS, SSRS)
• Dependency on remote servers (linked servers)
• Dependency on too much OPENXML(), XQuery, XPath
• Dependency on certain use cases of BULK INSERT APIs (see official docs for details)