uyBTF0BP

1Create extension if not exists tds_fdw;
2
3CREATE SERVER mssql_svr
4FOREIGN DATA WRAPPER tds_fdw
5OPTIONS (servername 'xxx.xxx.x.xx', port '1433', database 'db', tds_version     '7.1');
6
7CREATE USER MAPPING FOR postgres
8SERVER mssql_svr 
9OPTIONS (username 'sa', password 'xxxx');
10
11CREATE FOREIGN TABLE dbi (
12CF_ITEM_ID int NOT NULL,
13CF_ITEM_NAME varchar NULL,
14
15)
16SERVER mssql_svr
17OPTIONS (table 'dbo.tablemssql', row_estimate_method 'showplan_all');
18
19Create table if not exists tablepostgres as
20SELECT dbi.CF_ITEM_ID, dbi.CF_ITEM_NAME
21FROM dbi
22WHERE dbi.CF_ITEM_PATH LIKE 'AAAAABAABAAFAADAACAAA%';
23	
24try{
25// create a database connection
26$conn = new PDO('sqlsrv:Server=ip,1433;Database=db','sa','pass'); 
27// fonction testconn returns Connected if the connection is made.
28testconn($conn);
29
30}catch (PDOException $e){
31// report error message
32echo $e->getMessage();
33}
34$req = $conn->query('SELECT * FROM tablemssql');
35while ($r = $req->fetch())
36{
37print_r($r);
38}