And another one bites the dust! Wow – what a great group today… soooooo many questions! For those of you that weren’t there – the lecture was 80 minutes and the additional Q&A went on for another 45 minutes. So – as a result, there were *a lot* of additional resources needed. Let me get started with all of those right away.


To prepare for moving to SQL Server 2005 there are a few EXCELLENT resources with which you should start:


Phase 1 – Prepare to Upgrade/Migrate



Phase 2 – Database-level Testing



  • Copy Database Wizard or
  • Backup/Restore or
  • Detach/Attach

Phase 3 – Server-level Testing



  • Consider upgrade in-place or
  • Make sure that you manually migrate all EXTERNAL objects, logins, jobs, error messages, etc.

Phase 4 – Testing/Updating after the upgrade/migration



  • Update statistics immediately
  • Test application code, database compatibility modes, session settings
  • Check for “broken code” in terms of system table changes
  • MOST of this should have already been done and assessed in Phase 1 but better to be safe!

And – finally – the other things we talked about and the rest of the links are here:



And – that’s it for this week. See you next Friday when we chat about the new Management Tools and how to effectively use them!


Thanks for listening/watching and asking GREAT questions,
kt