July 21, 2010 at 3:36 am
Hi all
I need upgrading steps from sql server 2000 to 2005
Sudheer.k
July 21, 2010 at 4:19 am
run the upgrade advisor and look for issues.
If every thing is fine then script out the logins at 2000 - google how to transfer login between sql servers.
Then use backup/restore, detach/attach or copy database to move the databases.
also check for the compatibility level of database. keep it 80.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
July 21, 2010 at 5:20 am
Sqlfrenzy (7/21/2010)
also check for the compatibility level of database. keep it 80.
Why ? You will miss out on many 2005 benefits.
OP: This has been covered many times. Search for previous posts, then ask specific followup questions.
July 21, 2010 at 5:29 am
homebrew01 (7/21/2010)
Sqlfrenzy (7/21/2010)
also check for the compatibility level of database. keep it 80.Why ? You will miss out on many 2005 benefits.
OP: This has been covered many times. Search for previous posts, then ask specific followup questions.
yep u r right...but before you go to compatibility level 90, you should absolutely sure that ur code doesn't includes 2000 syntaxes that are deprecated in 2005. If this is the case , u need to modify the code first before changing the compatibility level.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
July 21, 2010 at 7:16 am
As previous stated, there are quite a few links on this forum that address this issue. This is one of my favorites.
http://www.sqlservercentral.com/Forums/Topic914723-391-1.aspx
Cindy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply