June 11, 2008 at 6:45 am
Hi Everyone
I wanted to know the problems that anyone encountered while migrating sql 2000 to sql server 2005.
What were the problems u encountered and how did u resolve it?
Thanku in advance
June 11, 2008 at 8:19 am
Before you start this project, be sure to run the upgrade advisor. It will look at your existing 2000 databases and point out the obvious errors or potential problems that you may encounter. In my particular instance, I have 20+ stored procedures written by our vendor that use the *= and =* join types which are not allowed in 2005 so I had to modify those stored procedures appropriately.
The other gotcha is user accounts. I actually ran a script to script out my existing user accounts so I would have the existing SIDs and passwords. Once I had those, I ran the script that was created on the new server so those users would still have access to their databases once I restored them into the new server.
Be sure to check with your vendors to make sure they are 2005 certified BEFORE you set the compatibility mode to 90. I have one vendor that will run on 2005 but we must keep the compatibility mode set to 80. They are working on certifying 90 but are not quite there yet. If I had set it to 90, I would have broken my application.
June 11, 2008 at 8:45 am
There are many things that can happen. The best thing you can do is run a test on a test system, upgrade things, and then if you have specific errors, come back and ask what to do about them.
Beyond the advice above, there could be many issues that occur, and it's hard to list all issues that might occur.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply