I have a linked server set, but I still have to connect to a MSSQL Server first in SSMS before I can refer to the linked server tables. If I want to the SSMS, but not with a SQL Server at all, how to I connect to a Postgres server using PGNP? At this stage we are still using MSSQL Server but only for the purpose of migrating to Postgres. Once complete, we want to kill the MS SQL Server and only use Postgres, but keep on using SSMS with PGNP. How can we do that?
Similarly, if we and to connect to a Postgres Server using MS Access, but without using ODBC, can we use PGNP for that and again how do we do that?