Ask Question
Computers and TechnologyComputers and Technology
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
You Might be Interested in
Which is a limitation of the grammar-checker tool?
Answers (1)
What is the Multiple Source Test? A. checking to make sure that information can be found in more than one place B. a fact-checking software that tests information found on the Internet C.
Answers (1)
During which step in "Steps to Solve a Problem" should students pick a strategy to use? Step 1 Step 2 Step 3 Step 4
Answers (1)
List and briefly explain two other Discovery / inventions that were necessary for the eventual development of the technology needed to create and listen to CDs
Answers (1)
Which of the following is not a description of RAM? 1. A type of computer memory that can be accessed randomly 2. Acronym for ramdom access memory 3. Is the most common type of memory found in computers 4.
Answers (1)
New Questions in Computers and Technology
In a class hierarchy, a. the more general classes are toward the right of the tree and the more specialized classes are toward the left. b.
Answers (1)
5. You were discussing software piracy with a friend and were surprised to learn how software piracy can impact your life every day. What is a risk or an effect of software piracy?
Answers (1)
Which of the following modes of replication, supported by Storage Replica, replicates data between sites over high-latency networks and provides no guarantee that data will be identical when a failure occurs?1. iSCSI Target2.
Answers (1)
What FAA-approved document gives the leveling means to be used when weighing an aircraft?
Answers (1)
To change a selected shape's height or width to a specific value, type the value in the Height or Width text boxes on the
Answers (1)
Home » Computers and Technology » 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.
Sign Up Forgot Password?