• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

The upgarde advisor of MS SQL

right now we will do side by side migration of DB from SQL server 2005 to SQL server 2008 R2, do we still need to run the upgrade advisor on SQL server 2005 RTM/SP2 ?

it is only need when we do in-place upgrade?
0
marrowyung
Asked:
marrowyung
  • 3
  • 2
  • 2
  • +2
2 Solutions
 
Matt BowlerDB team leadCommented:
side by side migration is not really an upgrade - so upgrade advisor is not necessary. You will need to ensure that your applications support apgradin gthe databases to 2008
0
 
jjjosefCommented:
It didn't need to be updated.

For more info go through this blog may it will help you out

http://sqlblog.com/blogs/aaron_bertrand/archive/2010/01/05/my-experiences-upgrading-2005-2008.aspx
0
 
marrowyungAuthor Commented:
jjjosef,

so no need too ?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Mark WillsTopic AdvisorCommented:
If you are moving one database to another , then ALWAYS run the upgrade advisor, even if not an upgrade in place.

Unless it is going to be a clean install, and building a database from scratch, then you need to know elements within your current database that might need closer scrutiny or attention.

Thats the entire idea behind the upgrade advisor. Upgrading also means going from one version to another.

So, the word "upgrade", is not meant to limit the use of the tool to an in place upgrade.

Having said that, it is vitally important for an in=place upgrade because of the very definition of being "in-place" and encountering one of those "oops" moments.

You should recall that Aaron article linked above - it was also posted in one of your other threads... Now, Aaron has been a MS MVP since 1997, and he runs the upgrade advisor "just in case", so, take that as your cue to run it from one of the most respected MVP's
0
 
marrowyungAuthor Commented:
mark_wills,

"You should recall that Aaron article linked above - it was also posted in one of your other threads... Now, Aaron has been a MS MVP since 1997, and he runs the upgrade advisor "just in case", so, take that as your cue to run it from one of the most respected MVP's "

I am respecting everyone here and Aaron you talking about is jjjosef?

DBA100.
0
 
Mark WillsTopic AdvisorCommented:
0
 
jjjosefCommented:
Ohkk so little confusion here regarding this blog which i have taken from sqlblog.com

first of all I am not Aaron ! and so the question is not about the author but about the query that he is facing ..
In the blog the author sharing their experience while migrating sql 2005 to 2008 ..he mentioned that upgrading advisor would be a good option in some cases it means Its not mandatory to upgrade advisor while migrating your SQL server .
0
 
marrowyungAuthor Commented:
0
 
Anthony PerkinsCommented:
I am sorry I am going to have to pass, you have too many open questions (19).
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now