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.