Why should we run the Upgrade Advisor?
Upgrade Advisor analysis and examines your instances of SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 of issues that can prevent you from upgrading or that can prevent your applications from working properly after upgrading.
How can i do this?
Visit Microsoft SQL Server 2012 feature pack website to download the below components
Prerequisite: Before installing Microsoft SQL Server 2012 Upgrade Advisor Microsoft SQL Server 2012 Transact-SQL ScriptDom needs to be installed– It’s a .Net Framework API that provides parsing and scripting services for Transact-SQL. This API supports SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 versions. Download: under the section of “MICROSOFT SQL SERVER 2012 ENGINE FETURE PACK COMPONENTS”
Install Microsoft SQL Server 2012 Upgrade Advisor
Under the section of “OTHER MICROSOFT SQL SERVER 2012 COMPONENTS” There is a sub section named “Microsoft SQL Server 2012 Upgrade Advisor”, Download x86(32 bit) and x64(64 bit) according to windows operating system compatibility
Below are the step by step screen shots for remaining setup.
To view the Previous Reports