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
