Upgrade to SQL Server 2005

If you are going upgrade from SQL Server 7 / 2000 to SQL Sercer 2005 you are highly recommended to use the following tools before you upgrade.

You have to run the Microsoft Upgrade Advisor which can be downloaded free. Microsoft SQL Server 2005 Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005. Upgrade Advisor identifies deprecated features and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.

Scalability Experts have developed a great tool, which helps you during upgrade process. You can download the SQL Server Upgrade Assistant for free. This tool analyses the impact associated with upgrading SQL Server 2000 installation to SQL Server 2005.

Thanks
Sutha