Change Database from Sql-Server 2000 to 2005

Hi ,

Currently my application running on Sql-Server 2000 and I want to upgrade with Sql-Server 2005
will It work sql- server 2005?

if no what changed i need to do?
Can anyone help me?

Thanx

Move the thread from Visual Basic General forum. The question is mainly on SQL Server upgrading issue. There are more exports in SQL Server Setup & Upgrade forum, I believe you can get the satisfying answer in this forum.

Thanks again for your question.

|||Yes ! There are 2 types of upgrades available,
1. Inplace upgrade
2. Side by Side upgrade

You can refer these documents,
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
http://www.sqlservercentral.com/columnists/ssamuel/2987.asp
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2068912&SiteID=1

In side by side upgrade you can choose any of the following,
1. backup db in sql 2000 and restore it in sql 2005
2. detach db in sql 2000 and attach it in sql 2005
3. copy database wizard

You need to install sql 2005 first and then perform as above

Inplace upgrade will automatically upgrade the existing sql 2000 instance to sql 2005 instance..........but you need to make use of upgrade advisor to check if any errors are reported and then take corrective actions and then proceed........you can go ahead with Inplace upgrade...........

http://msdn2.microsoft.com/en-us/library/ms144256.aspx upgrade advisor
http://msdn2.microsoft.com/en-us/library/ms144245.aspx