I am preparing for a SQL Server database migration. I would like to use the alias functionality from the SQL Server Native Client, configured with cliconfg.exe, to redirect my client applications to the new server. I am using this in conjunction with DNS aliases so I can redirect the connection to a new port. However, my applications use MSSQL JDBC instead of the native client.
Does MSSQL JDBC use the alias settings from the native client? Is it, by chance, a wrapper over the native client functionality? Both are provided by Microsoft. If not, does MSSQL JDBC have an equivalent client-hosted server name redirect functionality? How is this configured?
I did some preliminary testing with the native client settings and it seems like the JDBC driver does not utilize the alias. However, the naming schemes are a bit different between the two so I may not have had the names correct. I am referring to jdbc:sqlserver://servername:port compared to servername,port in the alias tool.
I asked the mssql-jdbc team and at this time (Dec 2022) the driver does not support aliases.