Microsoft SQL Server 2000 Upgrade

Question

Hi,

We have an application where we use Sql Server 2000 with vb 6.0. We are planning to upgrade this to a web application with Asp.net 2.0 and Sql server 2008.

I want to know the strategies for upgradation, What kind of challenges can come in upgradation to sql server 2008.

Regards,
Viki

Answer 1

   Hi Viki,

      The following will explain you clearly

       http://msdn.microsoft.com/en-us/library/bb677622.aspx

---

Lakshman

Answer 2

The first step would be to run SQL UPGRADE ADVISOR on sql 2000 instance and see what are the major issues and changes that you may have to do before you start the actual migration / upgradation. Also it is worth to read the contents from here http://msdn.microsoft.com/en-us/library/bb677622.aspx
The challanges depend on the mode of migration - In place or side by side installation and up gradation.

---

Thanks, Leks