A way to mapp a mssql server table to postgres foreign table28.11.16

1.
apt-get install libsybdb5 freetds-dev freetds-common

2.
apt-get install postgresql-server-dev-9.6 postgresql-common

3.
git clone https://github.com/GeoffMontee/tds_fdw.git

4.
cd tds_fdw

5.
make USE_PGXS=1

6.
make USE_PGXS=1 install

7.
/etc/init.d/postgresql restart

8.
create entry in /etc/freetds/freetds.conf

[mssql01]
        host = 192.168.0.1
        port = 1433
        tds version = 7.1
        instance = MSSQL01

9.
su - postgres

10.
create a database with:
createdb foo

11.
start psql by typing:
psql

12.
connect to the database foo
\connect foo

13
CREATE EXTENSION tds_fdw;

14.
execute the example queries:
CREATE SERVER sql01 FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'mssql01', database 'mssql_db', msg_handler 'notice');
CREATE USER MAPPING FOR postgres SERVER sql01 OPTIONS (username 'mssql_user', password 'mssql_pass');
CREATE FOREIGN TABLE zz_shortprices(short_code varchar NOT NULL,av0_style varchar NOT NULL) SERVER sql01 OPTIONS (schema_name 'dbo', table_name 'zz_shortprices');
SELECT * FROM zz_shortprices LIMIT 100 ;

http://azakirov.blogspot.com/2016/09/data-integration-between-postgresql-and.html

Anonymous

A way to mapp a mssql server table to postgres foreign table28.11.16

Information Epoch 1732629107