search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

Issues faced with ms sql server connectivity #1663

Closed SaravananNewt closed 10 months ago

SaravananNewt commented 11 months ago

Team, Ora2Pg version 24.0 is functioning correctly for Oracle connectivity. However, we have encountered connectivity issues when attempting to connect to MS SQL Server. ver_1_0_mssqlserver-knowhow_with-ora2pg240.docx

bharanisvng commented 11 months ago

Darold - per earlier issue suggestion , downloaded ora2pg ver 24.0 (dev version) and had followed readme instruction. Can you help us in rectifying the error.

darold commented 11 months ago

In your /etc/odbcinst.ini file replace section

[ODBC Driver 18 for SQL Server]

by

[msodbcsql18]

it must correspond to what you use as the DSN driver value: driver=msodbcsql18;server=...

SaravananNewt commented 11 months ago

Team Please provide the solution for the error i have encountered mssqlserver-postgres.docx

darold commented 11 months ago

Your file /etc/ofbc.ini should be empty, the definition are in /etc/odbcinst.ini

Also what is the purpose of \SQLEXPRESS after the server ip address? You should only have host=xxx.xxx.xxx.xxx

SaravananNewt commented 11 months ago

Team This is the updated file which has some issues in it. Please provide a solution V_ _3 for mssqlserver with ora2pg24.0.docx

SaravananNewt commented 11 months ago

Hi Team,

I hope this message finds you well. I'm writing to follow up on the recent updates made to our GitHub repository. Please the review my problem and provide a solution for the problem

SaravananNewt commented 11 months ago

Hi Team,

Please provide a solution for this problem to move further, where we have downloaded and checked the latest update in the community. I have attached the document for your reference V__4 for mssqlserver with ora2pg24.0.docx

darold commented 10 months ago

Look like you have not provided the right Ip address or port or it is filtered. I can't help much more on this.