x

SQL Server 7.0 to 2008 Upgrade

I have backed up 20 SQL 7.0 Databases. Restored the 20 SQL 7.0 Databses to SQL 2000. backed up the 20 SQL 2000 Databases and restored them to SQL 2008. Things seem to be working OK. I have seen a couple of options for the upgrading. This is one option I have seen. Am I missing anything?

Thanks,

bill

more ▼

asked Jun 11, 2010 at 04:34 PM in Default

avatar image

Bill Goetschius
53 2 2 6

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

6 answers: sort voted first

A few things that I would have added to this process. After restoring to 2000, I'd update the compatibility level to be sure it was set to 2000. Then I'd run the Microsoft Update Advisor to be sure that no deprecated code or structures find their way into the 2008 system. Then after the upgrade to 2008 I'd again update the compatibility level. Finally, this is required, but it's a good idea, manually update all the statistics on the database.

Other than these details, that's the approach I would have taken.

more ▼

answered Jun 14, 2010 at 09:11 AM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

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

Certainly seems like a good plan, as you've probably discovered there is no one-step upgrade from 7 to 2008. The only thing I would add is to carefully understand what functionality changes between 7 - 2000 and 2000 - 2008, so that when you discover issues after completing both steps, you will have an idea of which version to go back to make any necessary changes.

more ▼

answered Jun 12, 2010 at 10:40 AM

avatar image

Kev Riley ♦♦
66.2k 48 63 81

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

What you will be going with systems DB ???

After restore, you might get some backup error on SQL server 2008, here is the solution for that

www.sqlServer-Training.com

more ▼

answered Jun 11, 2010 at 05:52 PM

avatar image

DBATAG
1

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

I am with Grant on this one. Get yourself to a supported level where you can run the Upgrade Advisor with confidence - sometimes deprecated features only bite you much later on in the process and tend to bite at 2AM when you are in REM sleep. Grant points out the compatibility level change and the stats refresh, often times both of those steps are forgotten. As Grant points out this is exactly what MS recommends, not a bad way to go.

Grant I would have given you +1 on your answer but I still have < 15 rep. points.

more ▼

answered Jun 14, 2010 at 10:34 AM

avatar image

Scott Abrants
11

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

Thanks to everyone for your response. I tried to vote yes as far as your answers. However it says I need 15 to vote. I am very appreciative of everyone's time and knowledge.

 Bill

more ▼

answered Jun 23, 2010 at 12:54 PM

avatar image

Bill Goetschius
53 2 2 6

(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.

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:

x2188
x89
x5

asked: Jun 11, 2010 at 04:34 PM

Seen: 2987 times

Last Updated: Dec 13, 2012 at 03:14 PM

Copyright 2017 Redgate Software. Privacy Policy