SQL 2005 Migration to SQL 2008

Question

Post reply

SQL 2005 Migration to SQL 2008

iamanks

SSC-Addicted

Points: 416
More actions
December 18, 2010 at 12:13 am

#388466

Hello guys, I've been introduced to a new system having SQL Server 2005. I have given the responsibility to migrate it to SQL Server 2008.
What should be my steps/checklists/actions for migration from both developer as well as administrator point of view...?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135554 More actions · Answer 1

Are you already familiar with SQL2008.

If not, start testing it yourself !

maybe even get an upgrade course.

for your db/instance:

1) download SQL2008 upgrade advisor

2) run it against the db you want to migrate

3) work through the results

....

Use SQLServer Best Practice Analyzer to double check the existing instance and figure out why its remarks haven't been implemented for that instance.

Then determine of you can take its advises to the new instance.

Personally, I would prefer roll out on a new box or virtual os because that would guarantee I wouldn't get stuck on legacy stuff or e.g. old parts or dlls of the ancient edition

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

iamanks SSC-Addicted Points: 416 More actions · Answer 2

Thanks mate. Is there any document on recommended upgration/migration methodology or step by step guide ???

Though I'll make sure the same thing to test personally first...

Johan Bijnens SSC Guru Points: 135554 More actions · Answer 3

There are some articles at SSC and it the SSC fora.

e.g. http://www.sqlservercentral.com/articles/SQL+Server+2008/67066/

Search at SSC on "upgrade SQL2008" or "migrate SQL2008"

Here's a resource you should certainly have a look at because it is what MS recommends :

"How to: Upgrade to SQL Server 2008 R2" http://msdn.microsoft.com/en-us/library/ms144267.aspx