CODEWITHSUNDEEP
sqlsql-serverdatabasemacospostgresql
nejdetckenobi
nejdetckenobi

Reputation: 624

Connect a MSSQL created database with PostgreSQL

I use Mac and PostgreSQL is the choice for db management. I can not install MSSQL. There's a db which is created and managed by MSSQL. I must not copy the entire data via a script, to my database (because of using real time data) My only option is, connecting that MSSQL created db with PostgreSQL.

Is it possible? If yes, how? Will there be any relevant limitations for my queries? Thanks.

Additional details:

I'll make selections, calculations, statistically. I won't modify the existing data.

Upvotes: 1

Views: 2644

Answers (1)

pozs
pozs

Reputation: 36244

The feature, which allows you to connect to a different database from within PostgreSQL itself, is called foreign data wrapper.

Here, there is a list of available foreign data wrappers, but mssql is not included. But ODBC is, so (in theory) if you install odbc_fdw, you can access foreign mssql tables in your PostgreSQL instance.

There is also a tds_fdw for SQL Server which uses FreeTDS for the connection rather than ODBC

Upvotes: 2

Related Questions