'How to use two different versions of sql server in spring boot?
my question is how to make spring boot works with two different versions of sql server, 2008 and 2016 specifically.
The app need to get info from 2008 sqlserver database then it processes and save it's own app data to a 2016 sql server database
The spring boot version is v2.5.5
Update
I made a mistake, the version of SQL Server I need to work alongside 2016 is the 2000
Solution 1:[1]
Configure a data source for each of the databases. The documentation includes an example that you can refer to. Check that your JDBC driver is compatible with both SQL Server versions. When I tried to do something similar to you, but using Websphere 7 (it ran on Java 6) the available JDBC driver was only compatible with SQL Server 2008. If you run into problems then please ask a more specific question.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | James S |