SQL Server upgrades
link

SQL Server upgrades

Learn how to take an inventory of your SQL Server deployments using the Microsoft Assessment and Planning toolkit.

Microsoft Learn
Updated Jan 17, 2025

What you'll learn

  • Evaluate databases for upgrade to a newer version of SQL Server
  • Document the databases in your environment
  • Choose the appropriate method for upgrading a database
  • Test a database following an upgrade
  • Tune queries after migration to maintain performance
Course Description

Running the latest version of SQL Server provides you with numerous performance and functionality benefits while also extending the support of your database platform. In this learning path you will learn how to take an inventory of your SQL Server deployments using the Microsoft Assessment and Planning toolkit, how to upgrade SQL Server databases using the Data Migration Assistant, and how to optimize your updated system using both the Database Experimentation Assistant and Query Tuning Assistant.