Upgrading and Configuration

Database Upgrade

There are two ways that can be used to upgrade database instances:

• In-Place upgrade:A kind of upgrade the newer SQL instance will be installed on the same server that hosted the database instance that we want to upgrade. Rather than choosing new install, the upgrade option shall be picked so that the old instance will be replaced with the new instance. This option is relatively easy to do but it more risker than Side-by-Side upgrade
• Side-by-side: This process is essentially a new installation followed by a database migration. The new version of the database instance is installed in a separate server and then all the database objects will be moved from the old server to the new server.

Read More ...