SQL Server - Instance name and JDBC connection

Hello,

SQL Server has the concept of instances, meaning, that on a single server, multiple instances of SQL Server can be installed. For instance :

• my-server\InstanceA
• my-server\InstanceB

The instance is specified with a backslash after the serverName.

As per the Microsoft doc, the JDBC connection to connecto to SQL Server is:

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

My feed back is :

• While looking in SqlServerConnection.java, I saw that there exists a parameter INSTANCE_NAME, but in the Debezium Documentation, there are no mention of how to specify the instance.
• The reason I think is that it is not used. There exists a parameter URL_PATTERN, but it does not take into consideration the "\instanceName".

It might be enough to specify the instance as part of the serverName, ie serverName\instance. But because of backslash being confusing sometimes due to escaping, I would prefer to configure the instance in a separate configuration, as can be done in the classic JDBC connection string to SQL Server.

 Thanks for your consideration.

Best Regards,