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
Should be A.
It seems like D is valid to upgrade to 2014, not to 2012
SQL Server Upgrade Advisor helps you prepare for upgrades to SQL Server 2014. Upgrade Advisor analyzes installed components from earlier versions of SQL Server, and then generates a report that identifies issues to fix either before or after you upgrade.
0
0
https://msdn.microsoft.com/en-us/library/ms144256(v=sql.110).aspx
0
0