Chapter 3Upgrading SQL Server 2014 Best Practices


  • Planning an upgrade
  • Understanding discontinued and deprecated features
  • Choosing an upgrade method
  • Knowing what to watch for after the upgrade

Chapter 2, “SQL Server 2014 Installation Best Practices,” covers performing a new installation of SQL Server 2014. This chapter discusses upgrading SQL Server from a previous version. The best strategy for a successful upgrade is planning and preparation. First, you learn reasons for upgrading to SQL Server 2014. You then consider the pros and cons of various upgrade strategies, and you learn about the various tools available to help mitigate risk during the upgrade process. Then you learn about SQL Server 2014 behavior changes, and discontinued features that you need to know about before upgrading. To wrap up, this chapter explores unexpected issues you might encounter after the upgrade. By the end of the chapter, you will have learned everything you need to know to perform a successful upgrade to SQL Server 2014.


This book introduces significant enhancements throughout the product. During the development cycle, consider the three pillars of focus for the product: mission-critical confidence, breakthrough insight, and cloud on your terms. With the release of SQL Server 2014, Microsoft enhanced numerous features in the areas of scalability, reliability, availability, and security. Following are many benefits that these new features ...

Get Professional Microsoft SQL Server 2014 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.