1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
You may want to check out if the tds_fdw extension is supported on your Aurora PostgreSQL version: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html#AuroraPostgreSQL.Extensions.14
There are examples showing you how to connect to a Microsoft SQL Server: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Extensions.foreign-data-wrappers.html#postgresql-tds-fdw
Good luck!
답변함 일 년 전
Thanks! For the future - regrading Windows Authentication with this plugin, it doesn't look like it's doable unless MSSQL is using mixed authentication.
https://dba.stackexchange.com/questions/96885/foreign-data-wrappers-windows-authentication