Upgrade from SQL2000 to SQL 2008

Question

Upgrade from SQL2000 to SQL 2008

vamshidhar

Valued Member

Points: 56
More actions
January 4, 2010 at 11:47 pm

#228875

Hi ,
We are planning for a Upgrade from SQL2000 Enterprise edition to SQL2008 Standard Edition. Is that possible to do. Could any one help me gathering some valid points on how to upgrade the database.
Thanks....

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 1

I dont believe you can upgrade from SQL 2000 enterprise to SQL 2008 standard. Here is more details from the MS site on what is possible and supported.

Version and Edition upgrades

But you might be able to install a separate instance of SQL 2008 and migrate the databases.

vamshidhar Valued Member Points: 56 More actions · Answer 2

Hi,

Could u plz guide me in collecting the information on Migrating the existing database.

I'll guide u on the situation we r in.

We are right now working on SQl2000 enterprise edition installed on windows2003 server.

Now we want to migrate to SQl2008 Standard edition on windows2008 server.

Thanks......

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 3

High level. there are lots of things to consider when upgrading to SQL 2008. There is a lot of documentation available on the install media and on microsoft site.

At a high level.

Best thing to do would be to install a separate SQL Server 2008 instance on a separate machine.

Here is a detailed step-by-step.

Once, SQL 2008 is up and running, back up the SQL 2000 databases ans restore them here.

Here are the instructions for restoring.