We just upgraded to 2016 with our databases still in compatibility mode 2014. If I want to update to make them 2016 is there anything special I need to do since they are in Always On availability groups? Will updating on the primary automatically change on the secondary?
Answer by JohnM ·
As long as the corresponding applications are supported at the higher compatibility level, you can update them and the change will be sent to the secondaries automatically. I'd advise testing your applications first with the higher compatibility level before doing it in Production just to be safe.