I'm doing a proof of concept to assess whether we can upgrade some our servers piecemeal to SQL Server 2022.
Unfortunately we still have a SQL Server 2008 which holds an old version of Microsoft Dynamics which we cannot upgrade at this time :(
When trying to connect between SQL Server 2022, we notice that the query won't work as the SNAC has been removed in 2022.
I'm wondering whether there is another way to perform linked server requests across multiple databases and instances.
Has anyone managed to get it to work?
We think SQL Server 2019 --> SQL Server 2008 will work, as would SQL Server 2022 --> SQL Server 2012, but hoping someone has found a way of working around the driver problem, even if it's in the short term.
Anybody have any ideas?
select * from openquery(srv2019,'select * from srv2008.db.schema.table')