Microsoft SQL Server 2012 upgrade Advisor


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

https://www.microsoft.com/en-us/download/details.aspx?id=29065

Prerequisite:  Before installing Microsoft SQL Server 2012 Upgrade Advisor Microsoft SQL Server 2012 Transact-SQL ScriptDom needs to be installedIt’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.

Image

Image

ImageImage

ImageImageImageImageImageImage

Image

To view the Previous Reports

Image

Advertisements
This entry was posted in SQL SERVER 2012. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s