Introduction

Your organization might well have many databases that have a complex setup. You might have and many different database servers running different versions of Microsoft SQL Server. Such environments present complex problems to administrators seeking to ensure their software is up-to-date.

You're the senior administrator working for a long-established law firm. Over the years, the firm has expanded by acquiring smaller companies. Because each company within the group used databases in different ways, you now have to support lots of versions of SQL Server. Some of these SQL Server installs are now old and no longer supported by Microsoft. Crucially, some of them are not even in compliance with data protection legislation in your jurisdiction.

You have decided to upgrade older versions of SQL Server and you want to use the best tools to upgrade your databases with the least amount of impact on business systems and end users.

Learning objectives

In this module, you will:

  • Be able to evaluate databases for upgrade to a newer version of SQL Server
  • Be able to document the databases in your environment
  • Be able to choose the appropriate method for upgrading a database
  • Be able to test a database following an upgrade
  • Be able to tune queries after migration to maintain performance

Prerequisites

  • Ability to administer SQL Server databases at the intermediate level
  • Knowledge of backups and failure methodologies at the intermediate level
  • Understanding of query tuning and performance at the intermediate level