SQL Server DBA Tutorial 149-In Place Upgrade of SQL Server 2012 to SQL Server 2014 Part1

In this video you will learn In-Place upgrade of SQL Server 2012 to SQL Server 2014, you will learn following in this demo,
1- How to install SQL Server 2014 upgrade advisor
2- How to install pre-requisites of SQL Server 2014 upgrade advisor
3- How to take care of Upgrade advisor error " Upgrade advisor missing pre-requisites ....."
4- Best practices of In-place upgrade of SQL Server 2012
5- Rollback options in In-Place upgrade
6- How to run Upgrade Wizard of SQL Server 2014
7- How to view whether SQL Server 2012 is upgrade to SQL Server 2014 after Upgrade Wizard completes
8 - How to upgrade all management components from SQL Server 2012 to SQL Server 2014

Blog post link for this video

Visit our website to check out SQL Server DBA Tutorial Step by Step

[jimz]

A couple of things that were missed is you can run upgrade advisor from one central server and connect to many different SQL Servers. The first step is to open SQL Server configuration manager and add an alias to the central server you will be running Upgrade advisor from. Then connect to the server you are going to run upgrade advisor against and enable named pipes. We are in the process of upgrading 74 servers and I believe we have run into every issue imaginable.

[CRVgarage]

I would sum it up as Inplace upgrade is actual UPGRADE & Side by side upgrade is actual MIGRATION. Bc actual data transfer takes place in side by side approach.

[rsreejithtoo]

By Upgrade you mean..moving everything to a new SQL Server 2014 installation or upgrading the existing SQL Server 2012.?

[tejaaravind]

i am new to this data migration..can u let me know what is in place and parallel

[tejaaravind]

And can u suggest me a link which will help for the Starters

[oscaronorato]

Hi,

With the installation of the Upgrade Advisor 2014 I run it, but it takes hours and does not give me any reports.
Why can this be?