babelfishpg_tds
SQL Server TDS protocol extension
Overview
| 9320 | babelfishpg_tds | babelfishpg_tds | 1.0.0 | SIM | Apache-2.0 | C |
Attributes
| Yes | No | Yes | No | Yes | Yes | No | - |
Packages
| EL | PIGSTY | babelfishpg-tds* | 1.0.0 | - | 17 16 15 14 13 |
| Debian | PIGSTY | babelfishpg-tds | 1.0.0 | - | 17 16 15 14 13 |
Dependencies
This extension depends on: babelfishpg_tsql
Comments
works on wiltondb kernel fork
Availability
| PG17 | PG16 | PG15 | PG14 | PG13 | |
|---|---|---|---|---|---|
el8.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
el8.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
el9.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
el9.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
d12.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
d12.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u22.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u22.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u24.x86_64 | ✗ | ✗ | ✗ | ✗ | ✗ |
u24.aarch64 | ✗ | ✗ | ✗ | ✗ | ✗ |
CONTRIB
PGDG
PIGSTY
Download
To add the required PGDG / PIGSTY upstream repository, use:
pig repo add pgdg -u # add PGDG repo and update cache (leave existing repos)
pig repo add pigsty -u # add PIGSTY repo and update cache (leave existing repos)
pig repo add pgsql -u # add PGDG + Pigsty repo and update cache (leave existing repos)
pig repo set all -u # set repo to all = NODE + PGSQL + INFRA (remove existing repos)./node.yml -t node_repo -e node_repo_modules=node,pgsql # -l <cluster>Or download the latest packages directly:
Install
Install this extension with:
pig ext install babelfishpg_tds; # install by extension name, for the current active PG version
pig ext install babelfishpg_tds -v 15; # install for PG 15dnf install babelfishpg-tds*;apt install postgresql-15-babelfishpg-tds;./pgsql.yml -t pg_ext -e '{"pg_extensions": ["babelfishpg_tds"]}' # -l <cls>Create this extension with:
CREATE EXTENSION babelfishpg_tds CASCADE;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