You're reading from SQL Server 2019 Administrator's Guide A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions

Product type Paperback

Published in Sep 2020

Publisher Packt

ISBN-13 9781789954326

Length 522 pages

Edition 2nd Edition

Languages

SQL

Tools

SQL Server

Concepts

Database Administration

Authors (2):

Marek Chmel

Vladimír Mužný

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Provisioning the SQL Server Environment

2. Chapter 1: Setting Up SQL Server 2019 FREE CHAPTER

3. Chapter 2: Keeping Your SQL Server Environment Healthy

4. Section 2: Server and Database Maintenance

5. Chapter 3: Implementing Backup and Recovery

6. Chapter 4: Securing Your SQL Server

7. Chapter 5: Working with Disaster Recovery Options

8. Chapter 6: Indexing and Performance

9. Section 3: High Availability and the Cloud with SQL Server 2019

10. Chapter 7: Planning Migration and Upgrade

11. Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019

12. Chapter 9: Configuring Always On High Availability Features

13. Chapter 10: In-Memory OLTP – Why and How to Use it

14. Chapter 11: Combining SQL Server 2019 with Azure

15. Chapter 12: Taming Big Data with SQL Server

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

Chapter 7: Planning Migration and Upgrade

Although this book is about SQL Server 2019, you will not always be working with the latest versions and editions of SQL Server. You may be surprised how many diverse versions of SQL Server are still in production. Quite frequently, you'll face a task of upgrading and migrating the server configuration and content to the new server running the latest version of SQL Server. Each new version of SQL Server brings out many new features that are not available in older versions, and those features may be very useful for your environment to bring better performance, stability, and many other factors to your application. In this chapter, we'll explore the upgrade options for SQL Server and what you have to actually think about during the planning phase of the upgrade. This information will help you in upgrading your SQL Server systems to the latest version in a real environment.

Note

Migration of SQL Server is also usually bound...