0

I’m working on a Spring Boot WebFlux project and I’m planning to use R2DBC to interact with Microsoft SQL Server. However, I’m having difficulty finding clear information on which version of SQL Server supports R2DBC. Most of the resources I find seem to focus on Azure SQL Database, but I’m specifically interested in on-premises Microsoft SQL Server.

Can anyone confirm what the minimum version of SQL Server that supports R2DBC is?

Improve this question
6
  • You've got that backwards. Whatever r2dbc is must specify what versions of SQL Server it supports, not the other way around. Microsoft can't know every third-party driver and certainly can't provide support for it, unless they explicitly say otherwise. Microsoft provides its own multi-platfom ODBC drivers and includes proof-of-concept examples that show how to connect. Commented Mar 31 at 8:32
  • It seems to use <mssql-jdbc.version>12.2.0.jre8</mssql-jdbc.version> so i'm guessing it supports whatever that driver supports. The issue is probably which features of sql server it supports, you should look into github.com/r2dbc/r2dbc-mssql?tab=readme-ov-file and see what's missing Commented Mar 31 at 8:35
  • I asked the wrong question. What I actually want to know is how far R2DBC supports MSSQL. thank you. Commented Mar 31 at 8:39
  • Microsoft provides its own JDBC driver whose latest version is 12.10. Commented Mar 31 at 8:39
  • How far is a rope as we say here. I think it would be more productive if you wrote what you want it to support, or even better just try and see if it works Commented Mar 31 at 9:00
Related questions
4342
How do I UPDATE from a SELECT in SQL Server?
3327
How to add a column with a default value to an existing table in SQL Server?
2112
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.