Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

The upgarde advisor of MS SQL

Posted on 2013-02-06
10
Medium Priority
?
386 Views
Last Modified: 2013-02-26
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
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 10

Expert Comment

by:Matt Bowler
ID: 38862872
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
 
LVL 4

Assisted Solution

by:jjjosef
jjjosef earned 800 total points
ID: 38862914
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
 
LVL 1

Author Comment

by:marrowyung
ID: 38863228
jjjosef,

so no need too ?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 51

Expert Comment

by:Mark Wills
ID: 38863352
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
 
LVL 1

Author Comment

by:marrowyung
ID: 38863673
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
 
LVL 51

Accepted Solution

by:
Mark Wills earned 1200 total points
ID: 38863876
0
 
LVL 4

Expert Comment

by:jjjosef
ID: 38867017
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
 
LVL 1

Author Comment

by:marrowyung
ID: 38901110
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38904392
I am sorry I am going to have to pass, you have too many open questions (19).
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question