2

I have a SQL Server 2005 instance and also a PostgreSQL 9.3 running on the same network, I would like to know if its possible to somehow create or have 'views' on a database within the PostgreSQL server that show data coming from SQL Server.

1

Use:

  • Have you successfully manage to get data from MSSQL into a pg db?. I installed tds_fdw but documentation its only useful until you install then there's nothing to guide you through how are you supposed to get the tables from MSSQL... (?) – Nelz Mar 29 '15 at 17:53
  • 1
    @ZQL Once installed, you're supposed to follow the generic PostgreSQL documentation for foreign data wrappers I think. CREATE FOREIGN DATA WRAPPER, CREATE SERVER, CREATE USER MAPPING (if necessary), CREATE FOREIGN TABLE. See postgresql.org/docs/current/static/… and the see-also links there. – Craig Ringer Mar 29 '15 at 23:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.