Ask Question
29 August, 10:18

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

+2
Answers (1)
  1. 29 August, 13:40
    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?
Get 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 & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers