August 7, 2008 at 7:49 pm
Hi Folks,
I have been given a task to migrate a 2000 server to 2005 server. Currently the databases for the most part run through web applications. The thing is I have been given a test database server (to iron out any migration issues if there are any - I'm not sure as I have never done it before) but no webserver to point it to therefore I cannot set up a test environment for people who know the applications better to test. I am a bit lost now and I don't know how to validate my migration before we go live. Does anyone have any advice or ideas that can help me?
Also when restoring the databases the compatibility mode is 80. What are the ramofication putting it to 90?
August 7, 2008 at 8:17 pm
If you leave the databases in 8.0 mode you don't get the benefits of the additional functionality in SQL 2005. I'd change the compatibility mode, run Trace on the production database and then replay it on the 2005 database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply