O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Upgrading the Database Engine

You perform an in-place upgrade by running the SQL Server Installation Center. On the Installation page, you can invoke the Upgrade Wizard to upgrade from SQL Server 2005, 2008, 2008 R2, or 2012 (see Figure 9.16). The major steps performed by the SQL Server 2014 Installer program when performing an in-place upgrade include the following:

1. First, the SQL Server 2014 Setup prerequisites (Microsoft .NET Framework 3.5 Service Pack 1 (SP1) or a later version, SQL Server Native Client, and so on) are installed.

2. The Installer checks for issues that would prevent an upgrade. If it finds any, it will list them, and you must fix them and restart the upgrade process.

3. Setup installs the required SQL Server 2014 executables ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required