Upgrading from SQL Server 2005 to SQL Server 2008

The upgrade from SQL 2005 to SQL 2008 isn't difficult, but it's still worth seeing what is involved and some of the minor gotchas you might hit. Did you know that you can upgrade the tools only? Or that your full text catalogs will need to be rebuilt? Watch the video!

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

ajay on 1/29/2009

good video...........

siva kumar on 2/2/2009

Good

Sam on 2/12/2009

Very Informative !!!

Fred Mackie on 3/5/2009

I saw the ones on http://www.microsoft.com/events/series/msdnsqlserver2008.aspx, and this one is good, too.

luther smith on 6/8/2009

more, more!

Jeff Cantwell on 6/8/2009

Speaker needs to slow down his speech.

Travis on 6/8/2009

Slow down! Spaeker talks way to quickly...

Craig Pessano on 6/8/2009

I'm not sure about the answer to question one... I thought you could upgrade the tools only.

janet macdonald on 6/9/2009

Sometimes what he says in unintelligible -- he talks too fast so I have to listen to it a couple of time. Otherwise, a good video.

Milton Daniel on 6/13/2009

The speaker talks a little fast. The video is good.

stately on 6/25/2009

slow down speech

Mark Gelatt on 7/7/2009

The quiz popped up halfway through the video, blocking the view of the video. Maybe the video will be better the next time I view it.

Ted Quan on 7/28/2009

good

nitin on 7/29/2009

Brian, Your video tutorials are great, but I guess there are other factors you might try to explain like you showed in this video an in-place upgrade. There is side-by-side upgrade also. which you might mention the viewers about. Your videos are a great resource for many of us... Thanks, Nitin ...

Chris on 10/26/2009

An upgrade from SQL Server 2000 would have been useful too. With both In place and Side-by-Side options. Thanks for the video Brian.

ML Stephens on 1/8/2010

slow down

paul march on 4/20/2010

Helpful

A Alagu Ganesh on 6/15/2010

good

Sherry Shyu on 9/16/2010

The subject is too big to be covered within 5 minutes.

Johanna on 10/24/2010

Good night I found the presentation very good sql server 2008, but I have a problem with sql server 2005 to run the upgrade advisor for database sql server 2000, is showing the following messages and not to do: Object reference not set to an instance of an object. (VIEWCHECKOPT) and Several Issues upgrade not can be detected by Upgrade Advisor. To view undetectable Issues, click "Tell me more about this issue and how to resolve it." I would greatly appreciate your contribution to this major problem I have. Johanna M.

Worasi on 11/8/2010

Loved It. Straight to Point.

Scott on 3/3/2011

To the point, great!