tds_fdw

pig repo add pgdg -u    # add pgdg repo and update cache

pig install tds_fdw;		# install via package name, for the active PG version

pig install tds_fdw -v 18;   # install for PG 18
pig install tds_fdw -v 17;   # install for PG 17
pig install tds_fdw -v 16;   # install for PG 16
pig install tds_fdw -v 15;   # install for PG 15
pig install tds_fdw -v 14;   # install for PG 14

CREATE EXTENSION tds_fdw;

CREATE EXTENSION tds_fdw;

CREATE SERVER mssql_svr
  FOREIGN DATA WRAPPER tds_fdw
  OPTIONS (servername '127.0.0.1', port '1433',
           database 'tds_fdw_test', tds_version '7.1');

CREATE USER MAPPING FOR postgres
  SERVER mssql_svr
  OPTIONS (username 'sa', password 'secret');

CREATE FOREIGN TABLE mssql_table (
  id integer,
  name varchar(255),
  value numeric(10,2)
)
SERVER mssql_svr
OPTIONS (schema_name 'dbo', table_name 'mytable');

CREATE FOREIGN TABLE mssql_query (
  id integer,
  name varchar(255),
  total numeric(10,2)
)
SERVER mssql_svr
OPTIONS (query 'SELECT id, name, SUM(amount) AS total FROM orders GROUP BY id, name');

SELECT * FROM mssql_table WHERE id > 100;

-- View the remote query sent to SQL Server
EXPLAIN (VERBOSE) SELECT * FROM mssql_table WHERE id > 100;

IMPORT FOREIGN SCHEMA dbo
  FROM SERVER mssql_svr
  INTO public;