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 |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2008-04-22 : 09:39:32
|
| Hi,My IT collegues will soon migrate my databases from Sql2000 to Sql2005.Are there any nice opportunities that I should not miss?This migration is a loss of time for me, but if it could turn into an opportunity, I would be more happy with it. Any way to get some advantage from this migration?Thanks for your suggestions. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-24 : 23:11:37
|
| It's simply db backup/restore process. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-04-28 : 07:27:27
|
what is the exact scope of the migration procedure? is it just backup and restore or a migration script will be run?you should look into defragmenting your DBs if they need to be, adjusting the size of the log file to what is just needed, rewriting some routines you have so you take advantage of the new functions in 2005  HTH--------------------keeping it simple... |
|
|
|
|
|
|
2000 => 2005 migration, any opportunities ?