The side-by-side upgrade path is more complex compared to the in-place upgrade type, but it offers you more control over the overall process. In this type of upgrade, you will have two SQL Servers running and you will move the objects from one server to another. This will allow you a lot of space for testing, where two SQL Servers—the original and the new/upgraded one—can be evaluated from the application teams to resolve any possible issues. The original server will be intact and you will need to install a fresh new SQL Server with many choices:
- New hardware
- New virtual machine
- New SQL Server instance (least recommended option)
With new hardware or virtual machine, you can also have the benefit of installing the ...
