Ask Question
17 October, 03:59

You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL Server 2012. You want to evaluate to prepare for possible conflicts and issues that may arise during or after the migration. Which SQL Server tool should you use? A. Distributed Replay B. Migration Assistant C. Data Tools D. Upgrade Advisor D

+1
Answers (1)
  1. 17 October, 06:23
    0
    B. Migration Assistant

    Explanation:

    Migration assistant also referred to as the Data Migration Assistant (DMA) is a Microsoft tool used during SQL server upgrades to detect any compatibility issues that could impact the functionality of the new version of SQL server being installed. The Data Migration Assistant will also recommend performance and reliability improvements as well as allow you to move your SQL server data and schema from the source server to the destination server.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers