We would like to upgrade our SQL Server Database host to a new Windows Server 2022, running SQL Server 2022
1. What are the steps to do this?
2. Do we need to upgrade the driver as well or what driver do we need?
3. Are there any configurations that we need to change?
4. Can the backup be restored directly to the new DB or there steps that need to be done first?
The basic steps are as follows (as long as the accounts and passwords used to access the DBs don't change):
If you are using DevTest 10.7.2, or greater, you don't need to upgrade the driver for DevTest.
Note: The Broacom Client Services team pointed out that they have heard of reports of noticeable performance degradation for SQL Server 2019+. (https://dba.stackexchange.com/questions/268099/sql-server-2019-performance-worse-than-2012-am-i-missing-something). Therefore, you may want to consult with your SQL Server DBA before moving to SQL Server 2019 or SQL Server 2022.
Note: Service Virtualization release 10.7.2, has not certified SQL Server 2022. The Client Service's team has some labs that are using SQL Server 2022, and they said they have not had any issues yet. However, officially it's not been certified.