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?


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









For peering opportunity Autonomouse System Number: AS401345 Custom Software Development at ErnesTech Email AddressContact: [email protected]