Introduction to upgrading SQL Server
Microsoft Assessment and Planning (MAP) tool, Data Migration Assistant (DMA), and Database Experimentation Assistant (DEA) combine to provide full-cover assistance for start to finish SQL Server database upgrades. You can install all three tools on your local machine and connect them to the SQL Servers within your business landscape to discover old databases requiring upgrade, identify compatibility issues before you begin, upgrade a database to a target version, and then verify the performance of business-critical queries. This module shows you how to begin documenting your landscape, plan the most appropriate upgrade path, and test your migrated databases.
Learning objectives
In this module, you will:
- Identify 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.
Prerequisites
- Experience administering SQL Server databases
- Knowledge of backups and failure methodologies
- Understanding of query tuning and performance