跳转到主要内容

babelfishpg_tds

SQL Server TDS protocol extension

babelfish : SQL Server TDS protocol extension

Overview

ID Extension Package Version Category License Language
9320 babelfishpg_tds babelfish 1.0.0 SIM Apache-2.0 C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sLd-r No Yes Yes Yes yes no
Relationships
Requires babelfishpg_tsql
See Also tds_fdw odbc_fdw jdbc_fdw wrappers multicorn orafce db2fce
Siblings babelfishpg_common babelfishpg_tsql babelfishpg_money
special case: this extension only works on wiltondb kernel fork

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT PIGSTY 1.0.0 18 17 16 15 14 babelfish babelfishpg_tsql
RPM PIGSTY 6.0.0 18 17 16 15 14 babelfish-$v antlr4-runtime413
DEB PIGSTY 6.0.0 18 17 16 15 14 babelfish-$v libantlr4-runtime413
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
el8.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
el9.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
el9.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
el10.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
el10.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
d12.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
d12.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
d13.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
d13.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
u22.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
u22.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
u24.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
u24.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
u26.x86_64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A
u26.aarch64 PIGSTY 6.0.0 PIGSTY 5.4.0 N/A N/A N/A

Source 

pig build pkg babelfish;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install babelfish;		# install via package name, for the active PG version
pig install babelfishpg_tds;		# install by extension name, for the current active PG version

pig install babelfishpg_tds -v 18;   # install for PG 18
pig install babelfishpg_tds -v 17;   # install for PG 17

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'babelfishpg_tds';

Create this extension with:

CREATE EXTENSION babelfishpg_tds CASCADE; -- requires babelfishpg_tsql

Usage

Install go-sqlcmd:

curl -LO https://github.com/microsoft/go-sqlcmd/releases/download/v1.4.0/sqlcmd-v1.4.0-linux-amd64.tar.bz2
tar xjvf sqlcmd-v1.4.0-linux-amd64.tar.bz2
sudo mv sqlcmd* /usr/bin/

Try go-sqlcmd

$ sqlcmd -S 10.10.10.10,1433 -U dbuser_mssql -P DBUser.MSSQL
1> select @@version
2> go
version                                                                                                                                                                                                                                                         
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Babelfish for PostgreSQL with SQL Server Compatibility - 12.0.2000.8
Oct 22 2023 17:48:32
Copyright (c) Amazon Web Services
PostgreSQL 15.4 (EL 1:15.4.wiltondb3.3_2-2.el8) on x86_64-redhat-linux-gnu (Babelfish 3.3.0)                                        

(1 row affected)

Access pigsty exposed primary/replica service port

sqlcmd -S 10.10.10.11,5433 -U dbuser_mssql -P DBUser.MSSQL

sqlcmd -S 10.10.10.11,5434 -U dbuser_mssql -P DBUser.MSSQL