x

Upgrading to SQL Server 2008 from SQL Server 2005

If I have a SQL Server 2005 database, and want to upgrade it to run on 2008, what is the best approach, and what problems am I likely to encounter?

more ▼

asked Oct 11, 2009 at 06:36 AM in Default

Melvyn Harbour 1 gravatar image

Melvyn Harbour 1 ♦♦
1.4k 18 20 22

I'd upvote except I've used up all my vote3s for this voting period!
Oct 11, 2009 at 08:17 AM Mitch Wheat
(comments are locked)
10|1200 characters needed characters left

4 answers: sort oldest

The first thing you should do is download and run the Microsoft SQL Server 2008 Upgrade Advisor. Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help you prepare for upgrades to SQL Server 2008:

  • Upgrade Advisor does not change any configuration settings or data.

  • Upgrade Advisor can analyze remote instances of SQL Server, except for SQL Server Reporting Services. To analyze Reporting Services, Upgrade Advisor must be installed and executed on the report server.

  • Upgrade Advisor provides the UpgradeAdvisorWizardCmd command-prompt utility to help you more easily scan multiple instances of SQL Server. See the Upgrade Advisor documentation for additional information.

  • Uninstalling Upgrade Advisor requires the .NET Framework 2.0. Uninstall Upgrade Advisor before uninstalling the .NET Framework 2.0.

SQL Server 2008 Books Online: Using Upgrade Advisor to Prepare for Upgrades

Problems you might encounter:

more ▼

answered Oct 11, 2009 at 08:11 AM

Mitch Wheat gravatar image

Mitch Wheat
292 1 1 3

(comments are locked)
10|1200 characters needed characters left

Besides following the good advice provided by Mitch Wheat, when I upgrade between versions of SQL Server, I prefer to upgrade hardware at the same time. This way, I can install the new hardware, the new OS, and the new SQL Server version, and verify they are all working. Then, I perform a trial migration of the databases onto the new hardware and software, and then I can test the migration without affecting my existing installation. Once I am convinced the test migration was successful, I then make the actual cut over during an appropriate maintenance period. If there should be any problems with the cut over, I can always revert back to the older installation. When upgrading, I always prefer to have a back out plan ready, just in case.

more ▼

answered Oct 13, 2009 at 01:00 AM

Brad McGehee gravatar image

Brad McGehee
128 1 1 2

Sounds like the start of a plan for the SSC migration, Brad!
Oct 13, 2009 at 04:04 AM Melvyn Harbour 1 ♦♦
(comments are locked)
10|1200 characters needed characters left

This sounds like I have come to the right place for help...Preparing the process of moving to sql server 2008 from 2005 focusing focusing on consolidating all of the SQL servers that are out there on a core machine and have the different databases running on it.

Is there a step by step guide; this is my first time doing an upgrade of sql server

more ▼

answered Nov 30, 2010 at 08:55 AM

mcollette gravatar image

mcollette
1

Search this site for "upgrade". Here is the first question that caught my eye that had some form of a checklist (and a good one, at that): http://ask.sqlservercentral.com/questions/21142/upgrading-sql-2000-to-sql-2008
Nov 30, 2010 at 09:36 AM KenJ
(comments are locked)
10|1200 characters needed characters left

This sounds like I have come to the right place for help...Preparing the process of moving to sql server 2008 from 2005 focusing focusing on consolidating all of the SQL servers that are out there on a core machine and have the different databases running on it.

Is there a step by step guide; this is my first time doing an upgrade of sql server
more ▼

answered Nov 30, 2010 at 08:55 AM

mcollette gravatar image

mcollette
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1834
x343
x68

asked: Oct 11, 2009 at 06:36 AM

Seen: 4015 times

Last Updated: Oct 15, 2009 at 05:44 AM