Home > Articles > Details

How to Connect to PostgreSQL using ODBC 32bit Dsn and Connection String from SQL Server

Question: How do I connect to #PostgreSQL instance from #SQL Server #Management Studio to migrate the data and the Database Schema?


Please Login to see the rest of the answer
Answer:


1. Go to the Windows Search bar and type in "ODBC"
   - Look for ODBC 32bit and click on it.
     ODBC 32 bit connection to PostgreSQL from SQL Server

2. Navigate under "System DSN" and create or Add a #System #Data Source
    - Fill in the credentials for the PostgreSQL Server and click save

3. Start SQL Server Management Studio and click on the database you want to export the data from and click on Export data.

- On the Window that pops up select the Data source of ".Net Framework Data Provider for Odbc"

-  Then paste in the connection below:

Dsn={TypeInYourDSNNameHere};Driver={TypeInTheDriverNameAsItAppearsInODBC32Or64bit};server=192.168.1.xxx;port=5432;database={TypeInDatabaseName};uid={TypeInUserName};pwd=pasword





If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.


© 2022 - ErnesTech - Privacy