From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: noordeen.sf3844@gmail.com
Subject: BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application
Date: Thu, 22 Feb 2024 05:25:39 +0000
Message-ID: <18358-903b2055500ee584@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18358
Logged by: Noordeen zikutheen
Email address: noordeen.sf3844@gmail.com
PostgreSQL version: 16.2
Operating system: Windows
Description:
I changed the connection strings in the web.config file
and added connection strings, Entity Framework code and System.Data code.
But we are getting exception like this
Keyword not supported: 'port'
And when we tried to scaffold the PostgreSQL database in the dotnet 5, 6, 7
console app, we are getting error like this
Exception data:
Severity: FATAL
SqlState: 28000
MessageText: no pg_hba.conf entry for host "10.136.66.234", user "doadmin",
database "defaultdb", no encryption
File: auth.c
Line: 535
Routine: ClientAuthentication 28000: no pg_hba.conf entry for host
"10.136.66.234", user "doadmin", database "defaultdb", no encryption
enter image description here
We have a project and class library in .NET 4.5 and we are using Microsoft
SQL Server as database and we want to migrate the database into PostgresSQL.
I tried but I'm unable to migrate with the existing DbContext file. I didn't
get a solution for this yet
I am currently trying with the new console app in dotnet 8 and from
scaffolding method created models and DbContext file, again I am working
from the beginning. And from other dotnet version I was unable to scaffold
so gone with dotnet 8.
Can I have any solution to migrate from Microsoft SQL Server to Postgres
SQL?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, noordeen.sf3844@gmail.com
Subject: Re: BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application
In-Reply-To: <18358-903b2055500ee584@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox