Tool for Upgrading to SQL Server 2008

In this post i will let you know the tools provided(only 1 as i know) for upgrading your SQL Server 2005 instance to SQL Server 2008.
Upgrading from the previous version of SQL Server to a newer version is always a challenging task for a Database Administrator. In order to improve the SQL Server 2008 upgrade experience, Microsoft introduced a free tool called SQL Server 2008 Upgrade Advisor (SSUA). This tool basically does the analysis of installed components of the earlier SQL Server versions, and generates a report which has details about the issues that need to be fixed either before or after you upgrade to SQL Server 2008.

Features of SQL Server 2008 Upgrade Advisor

In this post we will discuss the features of SQL Server 2008 Upgrade Advisor tool.
Microsoft SQL Server 2008 Upgrade Advisor helps database administrators analyze the existing instances of SQL Server 2000 and SQL Server 2005 databases. It identifies features and configuration changes that might affect your successful upgrade to SQL Server 2008. Once the entire analysis is done by the tool, it documents all the upgrade issues along with providing a link for issue resolution. The tool also identifies all potential upgrade blockers that might occur during or after the upgrade without actually performing the actual upgrade. Database Administrators should utilize this wonderful tool during the upgrade planning phase of the project to analyze SQL Server 2000 and SQL Server 2005 instances. This tool can analyze different components of SQL Server such as SQL Server, Analysis Services, Notification Services, Reporting Services, Data Transformation Services, Integration Services, Scripts and SQL Trace Files. I strongly recommend using this tool in advance to avoid any last minute surprises during the actual upgrade. Prerequisites for Installing and Running Upgrade Advisor:
The .Net Framework 2.0 or a later version
Windows Installer 4.5 or a later version
Windows Server 2003 SP 1 or a later version, Windows Server 2008, Windows XP SP2 or a later version, Windows Vista

My First Post

This is my entrance to blogging.I like and work in Microsoft technologies.I will post all my knowledge on Microsoft technologies in this blog,which includes tutorials,sample codes,problem solutions,discussions and also comments and new releases of microsoft.You can contact me for solutions to your questions on Microsoft technologies through my Email jaipal.devarapalli@gmail.com

Disclaimer:Whatever the information shared in this blog is just my opinion/my knowledge and i request people not to take the information as suggestion or advice.If anyone has any statutory rights on the information posted here,it will be removed from the blog at the earliest of their information to us.I am not responsible for any legal action if the information posted here is misunderstood.Any discrepancies please mail me.