3 ms·

I've wanted this for a long time. Is there anything like this for Microsoft SQL Server?

• steve-chavez 7y ago
  You could use PostgreSQL Foreign data wrappers[1] and leverage PostgREST for a SQL Server schema. tds_fdw[2] works pretty well for this(I've used it in a project related to open data). Basically, you'd have to map mssql tables to pg foreign tables[3] defined on a pg schema. Lastly expose this pg schema through PostgREST. [1]: https://wiki.postgresql.org/wiki/Foreign_data_wrappers https://wiki.postgresql.org/wiki/Foreign_data_wrappers [2]: https://github.com/tds-fdw/tds_fdw/ https://github.com/tds-fdw/tds_fdw/ [3]: https://github.com/tds-fdw/tds_fdw/blob/master/ForeignTableCreation.md#example https://github.com/tds-fdw/tds_fdw/blob/master/ForeignTableC...