What are the differences and advantages between In-Place Upgrade and Side-By-Side Upgrade?

Started by Darragh, June 16, 2016, 12:22:27 PM

Previous topic - Next topic

Cooper

Hello, I have a problem to ask. Thank you How we do, what are the differences and advantages between in-place upgrade and side-by-side upgrade? Please inform me about the question.

Solomon

You can do an in-place upgrade, meaning that you reused the existing sever hitting UPGRADE in the setup. You can also do a side-by-side upgrade which means that you have a new server with a fresh sql installation and then you move the sql objects and the databases using scripts, detach/attach and/or backup/restore. (you can also mentioned as migration).