Categories
DBA

Overview of Upgrade Advisor Utility

Microsoft SQL Server 2005 Upgrade Advisor is a tool you can use to prepare for upgrades to SQL Server 2005. Upgrade Advisor analyzes installed SQL Server 2000 or SQL Server 7.0 components, and then generates a report that identifies issues that you must or should address to before or after upgrading to SQL Server 2005.

Categories
DBA

Installing Upgrade Advisor

This article will explain you in brief how to install upgrade advisor before installing SQL 2005

1.) Insert Sql 2005 setup CD DVD into drive and wait for auto menu to pop-up.

Categories
DBA

How to use Upgrade Advisor

Using Upgrade Advisor

This section will provide you a brief about How to upgrade advisor

1.) Go to Start –> All Programs –> Microsoft SQL Server 2005 –> SQL Server 2005 Upgrade Advisor, open upgrade advisor

Categories
DBA

Installing SQL Server 2005

Before we begin the installation, login into the server with admin rights.

1.) Insert the SQL server CD DVD and wait for auto-menu to popup.