Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
david32
Starting Member
15 Posts |
 Posted - 2008-08-07 : 21:51:29
|
| 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? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-07 : 22:48:50
|
| Backup/Restore,Attach/Detach.We actually cover this issue everyday. Please Search and you will find lots of posts in SQLteam.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 22:58:14
|
| >> when restoring the databases the compatibility mode is 80. What are the ramofication putting it to 90?You have to fully test it with apps, otherwise never know what will happen. Can you just set a testing web server? |
|
|
|
|
|
|
2000 to 2005 migration