Migrating to SQL Server 2014


SQL Server 2014’s new In-Memory OLTP, with its 2x-30x performance improvements, provides a pretty compelling reason to migrate to SQL Server 2014—in spite of the fact that SQL Server 2014 was released just two years after the last SQL Server 2012 release.

There are two basic strategies for upgrading to a new SQL Server release. Some people recommend performing a full backup followed by a clean install of SQL Server on a new operating system. Other people prefer performing in-place upgrade. Each different tact has their advantages.

Full Backup Followed by Clean Install

People who prefer the clean upgrade say you minimize the register and system corruption that eventually creeps into all Windows installation. Thereby giving you a more stable new installation. This is essentially the same as performing a new installation. However, this method is time consuming and costly. You need to restore all of your databases and in many cases need to buy a new Windows Server OS license. Then you need to restore any custom SQL Server settings and properties that you may have changed.

In-Place Upgrade is Much Faster

Alternatively, performing an in-place upgrade is much faster as you only need to install the need SQL Server version over top of the old one. There’s no need to backup and restore. Some database pros say this method is safer because you know you’ll be running with the same settings and they don’t like to change an otherwise stable system. I have performed both successfully many times in the past. In this article I’ll cover the steps for performing an in-place upgrade of SQL Server 2012 to SQL Server 2014.

You can perform an in-place upgrade to SQL Server 2014 using the graphical Installation Center or you can upgrade by running setup.exe from a command prompt using a configuration file. In this article I’ll guide you through the setup of migrating to SQL Server 2014 using the Installation Center. For more information about using a configuration file you can refer to Install SQL Server 2014 Using a Configuration File. The SQL Server 2014 installation process supports upgrading from the following versions of SQL Server

  • SQL Server 2012 SP1
  • SQL Server 2008 R2 SP2
  • SQL Server 2008 SP3
  • SQL Server 2005

You cannot perform an in-place upgrade for older versions of SQL Server such as SQL Server 2000, SQL Server 7.0, or SQL Server 6.5. In addition, you cannot add features during the upgrade process. In general, you can upgrade from your current edition to of SQL Server to the equivelant or higher editions. For instance, you can upgrade from the SQL Server 2008 R2 SP2 Datacenter edition (the highest for that release) to the SQL Server 2013 Enterprise or Business Intelligence editions. Likewise, you can upgrade for the SQL Server 2012 SP1 to the SQL Server 2014 Standard, Enterprise, or Business Intelligences editions. The Developer Edition can only be upgraded to the Developer Edition. For a complete list of supported upgrade paths to SQL Server 2014 you can refer to Supported Version and Edition Upgrades

SQL Server 2014 Hardware Requirements

SQL Server 2014 is designed to run on a wide range of computer systems from laptop and desktop systems to enterprise class systems. The minimum processing requirement for a 32-bit x86 implementation is a 1.0 GHz CPU, while the 64-bit x64 implementation has a recommended minimum of a 1.4 GHz processor. Microsoft’s recommended minimum processor speed is 2.0 GHz. The minimum memory requirements for SQL Server 2012 are also quite low. The low end SQL Server 2012 Express edition requires a minimum of 512 MB while the other editions require a minimum of 1 GB or RAM. Microsoft’s recommended minimum RAM for the SQL Server 2014 Standard edition and above is 4 GB. Disk space requirements vary depending on the features that you install. SQL Server 2014 requires a minimum of 6GB of free disk space.

SQL Server 2014 Operating System Requirements

SQL Server 2014 is designed to run in wide variety of situations and each different SQL Server 2014 edition has different operating system requirements. In addition, the 32-bit x86 versions and the 64-bit x64 versions of the different SQL Server 2014 editions also have somewhat different operating system requirements. The following table lists all the supported operating systems for the principle editions of SQL Server 2014.

SQL Server 2014 Edition 32-bit 64-bit
SQL Server 2014 Enterprise Windows Server 2012 R2 64-bit Datacenter

Windows Server 2012 R2 64-bit Standard

Windows Server 2012 R2 64-bit Essentials

Windows Server 2012 R2 64-bit Foundation

Windows Server 2012 64-bit Datacenter

Windows Server 2012 64-bit Standard

Windows Server 2012 64-bit Essentials

Windows Server 2012 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

Windows Server 2008 SP2 32-bit Datacenter

Windows Server 2008 SP2 32-bit Enterprise

Windows Server 2008 SP2 32-bit Standard

Windows Server 2008 SP2 32-bit Web

Windows Server 2012 R2 64-bit Datacenter

Windows Server 2012 R2 64-bit Standard

Windows Server 2012 R2 64-bit Essentials

Windows Server 2012 R2 64-bit Foundation

Windows Server 2012 64-bit Datacenter

Windows Server 2012 64-bit Standard

Windows Server 2012 64-bit Essentials

Windows Server 2012 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

SQL Server 2014 Business Intelligence Windows Server 2012 R2 64-bit Datacenter

Windows Server 2012 R2 64-bit Standard

Windows Server 2012 R2 64-bit Essentials

Windows Server 2012 R2 64-bit Foundation

Windows Server 2012 64-bit Datacenter

Windows Server 2012 64-bit Standard

Windows Server 2012 64-bit Essentials

Windows Server 2012 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

Windows Server 2008 SP2 32-bit Datacenter

Windows Server 2008 SP2 32-bit Enterprise

Windows Server 2008 SP2 32-bit Standard

Windows Server 2008 SP2 32-bit Web

Windows Server 2012 R2 64-bit Datacenter

Windows Server 2012 R2 64-bit Standard

Windows Server 2012 R2 64-bit Essentials

Windows Server 2012 R2 64-bit Foundation

Windows Server 2012 64-bit Datacenter

Windows Server 2012 64-bit Standard

Windows Server 2012 64-bit Essentials

Windows Server 2012 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Web

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Web

SQL Server 2014 Standard Windows Server 2012 R2 64-bit Datacenter

Windows Server 2012 R2 64-bit Standard

Windows Server 2012 R2 64-bit Essentials

Windows Server 2012 R2 64-bit Foundation

Windows Server 2012 64-bit Datacenter

Windows Server 2012 64-bit Standard

Windows Server 2012 64-bit Essentials

Windows Server 2012 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Web

Windows 8.1 32-bit

Windows 8.1 Pro 32-bit

Windows 8.1 Enterprise 32-bit

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 32-bit

Windows 8 Professional 32-bit

Windows 8 64-bit

Windows 8 Professional 64-bit

Windows 7 SP1 64-bit Ultimate

Windows 7 SP1 64-bit Enterprise

Windows 7 SP1 64-bit Professional

Windows 7 SP1 32-bit Ultimate

Windows 7 SP1 32-bit Enterprise

Windows 7 SP1 32-bit Professional

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Foundation

Windows Server 2008 SP2 64-bit Web

Windows Server 2008 SP2 32-bit Datacenter

Windows Server 2008 SP2 32-bit Enterprise

Windows Server 2008 SP2 32-bit Standard

Windows Server 2008 SP2 32-bit Web

 

Windows Server 2012 R2 64-bit Datacenter

Windows Server 2012 R2 64-bit Standard

Windows Server 2012 R2 64-bit Essentials

Windows Server 2012 R2 64-bit Foundation

Windows Server 2012 64-bit Datacenter

Windows Server 2012 64-bit Standard

Windows Server 2012 64-bit Essentials

Windows Server 2012 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Datacenter

Windows Server 2008 R2 SP1 64-bit Enterprise

Windows Server 2008 R2 SP1 64-bit Standard

Windows Server 2008 R2 SP1 64-bit Foundation

Windows Server 2008 R2 SP1 64-bit Web

Windows 8.1 64-bit

Windows 8.1 Pro 64-bit

Windows 8.1 Enterprise 64-bit

Windows 8 64-bit

Windows 8 Professional 64-bit

Windows 7 SP1 64-bit Ultimate

Windows 7 SP1 64-bit Enterprise

Windows 7 SP1 64-bit Professional

Windows Server 2008 SP2 64-bit Datacenter

Windows Server 2008 SP2 64-bit Enterprise

Windows Server 2008 SP2 64-bit Standard

Windows Server 2008 SP2 64-bit Foundation

Windows Server 2008 SP2 64-bit Web

Windows Server Core Support

Like the earlier SQL Server 2012 release, SQL Server 2014 provide full support for running on Windows Server Core. Windows Server Core is the minimal Windows Server implementation which runs without the graphical shell—this provides a lower overhead and smaller attack and patching surface than a full Windows Server implementation. SQL Server 2014 is supported on Server Core mode in the following editions of Windows Server:

  • Windows Server 2012 R2 64-bit Datacenter x64
  • Windows Server 2012 R2 64-bit Standard x64
  • Windows Server 2012 64-bit Datacenter x64
  • Windows Server 2012 64-bit Standard x64
  • Windows Server 2008 R2 SP1 Datacenter x64
  • Windows Server 2008 R2 SP1 Enterprise x64
  • Windows Server 2008 R2 SP1 Standard x64
  • Windows Server 2008 R2 SP1 Web x64

SQL Server 2014 Software Requirements

SQL Server 2014 also has a few software requirements beyond the base operating system. The primary software requirements are:

  • The .NET Framework 3.5 SP1 is required when you select Database Engine, Reporting Services, Master Data Services, Data Quality Services, Replication, or SSMS. This is not installed by the SQL Server setup process.
  • The .NET Framework 4.0. This is installed by the SQL Server setup process.
  • PowerShell 2.0 or higher is required if you have installed the database engine or SSMS.
  • The Windows Installer service must be running.

For more information about the prerequisites for installing SQL Server 2014 you can refer to Hardware and Software Requirements for Installing SQL Server 2014.

Mehboob
— Microsoft Certified Solutions Associate (MCSA)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s