October 26, 2021 at 2:20 pm
There is a Microsoft application that uses sqlncli10.dll to connect to a 2008 r2 database. In the process of migrating last remaining databases from the old 2008 r2 sql server to sql 2019 server.
Will the connection still work after migrating to sql server 2019 if database compatibility is set to 2008 in the new server? If not, would appreciate any inputs on what needs to be done.
October 26, 2021 at 2:55 pm
Given that both 2008 and the native client are all depreciated you run it all at your own risk.
Even the latest native clients are depreciated in favour of the new msoledb provider.
Test test test is the only thing I can suggest and if it doesn't work you need to upgrade the app to a supported driver.
October 26, 2021 at 2:59 pm
My opinion - test it out.
Upgrading from 2008 R2 to 2019 MAY require upgrading your OS as well and, if I remember right, 2019 doesn't support 2008 compatibility mode.
What I would do - run this through a test environment and test your upgrade to make sure it goes smoothly. If it doesn't, you only blew up a test environment that you can rebuild and try again. If it does go smoothly, you have a documented process to do the upgrade and you can have a list of things you tested.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply