Which SQL Server tool should you use?

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?

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

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

Patty

Patty

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.

Reply