Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-2328

Dynamic port support for SQL Server

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Unresolved
    • Major
    • None
    • None
    • sqlserver-connector
    • None
    • 0
    • 0% 0%

    Description

      There are two forms of JDBC URL for connecting to MSQSQL
      1. Using hotname+port
      2. Using hostname/instancename (Dynamic Port)

      Example here:
      https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017

      Option 2 is used to support scenarios where the port number may change (in this prospects case, SQL Server runs as a 6 node failover cluster running 12 instances).

      Debezium does not support option 2:
      Line 64 from here: https://github.com/debezium/debezium/blob/master/debezium-connector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerConnection.java

       

      Could SQL Server connector support hostname/instancename (Dynamic Port)?

      Attachments

        Activity

          People

            Unassigned Unassigned
            nathan.nam Nathan Nam (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: