March 24, 2008 at 7:15 am
Hello,
We are having SQL Server 2000 and are in the process of migrating
it to SQL 2005.
Does anyone have any tips & tricks or lessons learned? Also, what are the alternate ways to upgrade and which one would suit
better for a small sized DB environment?
Thanks,
Ramesh.
March 24, 2008 at 8:38 am
May start from this checklist: http://technet.microsoft.com/en-us/library/ms143695.aspx
For more details, "SQL Server 2005 Upgrade Technical Reference Guide"
Important thing is to fully TEST in your environment, including application testing. Performance issue may come up after upgrading is completed for a while. Make sure the driver is compatibile with SQL 2005.
March 24, 2008 at 8:47 am
BTW, I am wondering this question "what are the alternate ways to upgrade?"
---> Why look for alternate ways rather than Microsoft suggested/supported?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply