search

BuzzCutNorman / tap-mssql

Singer Tap for MS SQL built with Meltano Singer SDK.
MIT License
2 stars 9 forks source link

Added MultiSubnetFailover to sqlalchemy_url_query #69

Closed BuzzCutNorman closed 1 year ago

BuzzCutNorman commented 1 year ago

This is to meet MS recommendation for connecting to SQL Server using ODBC Driver connection strings:

Always specify multiSubnetFailover=Yes when connecting to the availability group listener of a SQL Server availability group or a SQL Server Failover Cluster Instance. multiSubnetFailover=Yes configures SQL Server Native Client to provide faster detection of and connection to the (currently) active server. Possible values are Yes and No. The default is No.

https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/using-connection-string-keywords-with-sql-server-native-client?view=sql-server-ver16