Looking at the definition of postgres_fdw, we notice a comment: "The functionality provided by this module overlaps substantially with the functionality of the older dblink module". It is meant to access a foreign table from PostgreSQL in general, while tdw_fdw appears to be specific to MS SQL Server. Both access data from a PostgreSQL server, while you want to access a PostgreSQL instance from MS SQL Server. To this purpose, you may consider other solutions, for instance Connecting SQL Server Management Studio to PostgreSQL via ODBC Driver.
This discussion group is oriented more towards general opinions, trends, and issues of general nature touching App Engine and Cloud SQL. For coding and programming architecture, as well as setting up MySQL instances, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help.
On Friday, 02 July 2021 at 12:49:34 UTC-4 vishnu...@bmg.com wrote:
Hello Team,I wanted to query from the Microsoft SQL Server database to Cloud SQL PostgreSQL.We don't have the support for the extension tds_fdw in GCP Cloud SQL.Is there any other option for achieving the same? Will postgres_fdw will be any kind of useful?Thanks,Vishnu Mohan
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/00ed272c-25ec-4657-9fdf-ec0524dba9bdn%40googlegroups.com.
No comments:
Post a Comment