Updated on 2025-11-28 GMT+08:00

Introduction

TaurusDB for PostgreSQL Babelfish provides a SQL Server syntax compatibility layer, enabling T-SQL applications to run seamlessly in a PostgreSQL environment. Its main features are as follows:

  • T-SQL syntax compatibility: SQL Server syntax elements such as stored procedures, triggers, and functions are supported.
  • Data type mappings: SQL Server-specific data types (such as NVARCHAR and DATETIME2) are automatically converted to equivalent PostgreSQL data types.
  • Protocol compatibility: A TDS port (1433 by default) is used to provide connections compatible with the native protocol of SQL Server.

Scenarios

  • SQL Server migration to the cloud: SQL Server applications on-premises or on other clouds can be migrated to Huawei Cloud PostgreSQL.
  • Multi-database integration: PostgreSQL manages legacy systems that are compatible with SQL Server.

Related Services

  • Database and Application Migration UGO (UGO): You can use Huawei Cloud UGO's object migration feature to migrate data objects such as stored procedures, functions, and views from the source SQL Server database to TaurusDB for PostgreSQL.
  • Data Replication Service (DRS): a one-stop migration solution that supports full and incremental data synchronization and online data migration.

For more information, see the official Babelfish documentation.