babelfishpg_tds
SQL Server TDS protocol extension
Module:
Categories:
Overview
Extension: babelfishpg_tds : SQL Server TDS protocol extension
Information
- Extension ID: 9120
- Extension Name:
babelfishpg_tds - Package Name:
wiltondb - Category:
SIM - License: Apache-2.0
- Website: https://babelfishpg.org/
- Language: C
- Extra Tags:
mssql - Comment:
Metadata
- Latest Version: 1.0.0
- Postgres Support:
15 - Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSIONDDL - Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
babelfishpg_tsql
RPM / DEB
- RPM Repo: WILTON
- RPM Name:
babelfishpg-tds* - RPM Ver :
1.0.0 - RPM Deps: N/A
- DEB Repo: WILTON
- DEB Name:
babelfishpg-tds - DEB Ver :
1.0.0 - DEB Deps: N/A
Packages
| OS | Arch | 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 |
Installation
Install babelfishpg_tds via the pig CLI tool:
pig ext install babelfishpg_tds
Install babelfishpg_tds via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["babelfishpg_tds"]}' # -l <cls>
Install babelfishpg_tds RPM from YUM repo directly:
dnf install babelfishpg-tds*;
Install babelfishpg_tds DEB from APT repo directly:
apt install babelfishpg-tds;
Enable babelfishpg_tds extension on PostgreSQL cluster：
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
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.