Avatar of JustinGSEIWI
JustinGSEIWI
 asked on

SQL upgrade advisor help

I am going to try and upgrade SQL from 2005 to 2008 R2 next week. I have just ran the upgrade adviser and attached the report.

I am no SQL expert and don't know how to interpret this report or how to fix what it suggests.

I am only concerned with the WSS_content, MVGSC, GSEIW databases.

The primary reason I am doing this is because I need to upgrade Great Plains to 2013 from version 10 and it requites SQL 2008 instead of 2005.

Thanks,

Justin
sql-log.csv
sql-log1.csv
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Ryan McCauley

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan McCauley

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
JustinGSEIWI

ASKER
Thank you for the reply.

I ran it again and this time did not get the timeouts. The SQL server is a virtual server on ESXi5. I was running the test locally on the SQL server itself.

We are a simple shop and I see no need to change compatibility levels unless GP requires it for some reason.

Please let me know what you think of the new log file.

Justin
sqlloggp.csv
SOLUTION
Ryan McCauley

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
JustinGSEIWI

ASKER
So to confirm, the items pointed out with SQL update adviser would only be an issue if I upgrade my compatibility level? How do I confirm the compatibility level of my databases?

Then I am fine with ignoring the flagged items in the logs i posted? If I needed to, how would I go about resolving the items that were flagged?

Thanks,

Justin
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
JustinGSEIWI

ASKER
I checked the compatibility level for all databases. Most of them are 90 with a couple set to 80. So it looks like I can safely upgrade from 2005 to 2008 R2 with no trouble right?

I am creating a copy virtual machine of my production SQL server tonight. Then I will use the copy to do a test upgrade early next week and see how it goes.

Anything else you can think of that would be helpful for me to know during this upgrade?

Thanks again!

Justin
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.