Upgrading to SQL Server 2008 R2 or SQL Server 2012

For those starting to think about upgrading to SQL 2012, or for SQL 2008 sites, should I upgrade to SQL 2008 R2 or SQL 2012, you will find the SQL Server Upgrade Advisor an excellent first step and rewarding toe in the water experience.

A link to the upgrade advisor can be reached here that includes the links to download the tool SQL Server 2008 R2 Upgrade Advisor Link – ordinarily this would be available in the SQL 2008 R2 feature pack.

Running the upgrade advisor is simple and allows you to select and analyse only the components you are thinking about upgrading.  For example if you only want to upgrade Reporting Services, then only select the Reporting Services option.  Keep in mind, for Reporting Services, you must install and run the tool locally on the Reporting Services server, whereas for the other components (SQL Server, Analysis Services, etc) you can analyse from a client workstation that has upgrade advisor installed.  Any issues can be viewed later using the same upgrade Advisor tool but using the Report Viewer option.

The link to the current SQL 2012 Release Candidate Upgrade Advisor is here SQL Server 2012 Upgrade Advisor Link.

I also recommend running the SQL Server Best Practices Analyser to help identify risk areas that might be better sorted out before you plan to do the upgrade.  The link to the Best Practices Analyser can be found here SQL Server 2008 R2 Best Practices Analyser Link.  BPA also performs some O.S. level checks so is recommended to install and run on the actual SQL Server you intend to analyse.  It is also works on SQL 2008 instances.

Currently, the SQL 2012 Best Practices Analyser defers to the SQL 2008 R2 version SQL Server 2012 Upgrade Quick Sheet.

Hope this helps.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

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