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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot