MSSQL and PostgreSQL Linked Server Configuration –DB LINK

Install PostgreSQL ODBC Driver

Browse to PostgreSQL’s official download site for psqlODBC and download the zip file containing the x64 bit .msi installer and you can installation the process.

Create ODBC Data Source

Create a SQL Server Linked Server to PostgreSQL

Choose the fourth option (“Be made using this security context”) and provide a login name and password to connect to the remote PostgreSQL instance. In this case, we have used the built-in Postgres superuser account to keep things simple

--

--

--

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.

Love podcasts or audiobooks? Learn on the go with our new app.

A beginner’s guide to Capture The Flag

PlasmaPay Partners with Geeq

The 2018 Web Developer Roadmap

5 Advance Features of FastAPI You Should Try

How to root Alcatel One Touch Pop C5 5036x

ScreenShot_20160422225054

How to Manage Machine Learning Development Like the Pros

Influenced by pointillism- Software engineer’s guide to product management

CI/CD

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alim Dogan

Alim Dogan

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.

More from Medium

MinIO SDK Using REST API .NET

Getting Started With Apache Kafka

Easy Unit Test Coverage to your CI-CD Pipeline with reports and coverage limit.

Rate Limiting using Kong API Gateway