upgrading from 2008r2 to 22014 questions

Question

upgrading from 2008r2 to 22014 questions

Quinn-793124

SSCrazy

Points: 2785
More actions
July 1, 2016 at 2:52 pm

#327501

Hi,
How do you determine of SQL Server 2008 I am on so I can get the same level at 20014 so I don't lose functionality and compatible with ESRI ArcGIS Server version 10.4.1 enterprise edition
I looked in management studio and couldn't find it there.
Thanks much.
Quinn

Viewing 7 posts - 1 through 6 (of 6 total)

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

Smendle Hall of Fame Points: 3969 More actions · Answer 1

Quinn-793124 (7/1/2016)
Hi,
How do you determine of SQL Server 2008 I am on so I can get the same level at 20014 so I don't lose functionality and compatible with ESRI ArcGIS Server version 10.4.1 enterprise edition
I looked in management studio and couldn't find it there.
Thanks much.
Quinn

I am not sure what you are asking for here exactly but if its compatibility levels than there is a neat article here at SSC that has some SQL to get you compatibility levels.

ARTICLE[/url]

Jeff Moden SSC Guru Points: 1004403 More actions · Answer 2

Quinn-793124 (7/1/2016)
Hi,
How do you determine of SQL Server 2008 I am on so I can get the same level at 20014 so I don't lose functionality and compatible with ESRI ArcGIS Server version 10.4.1 enterprise edition
I looked in management studio and couldn't find it there.
Thanks much.
Quinn

My personal opinion is that you should contact ESRI and ask them very specifically. You, me, and everyone else stands the chance of being wrong or missing important documentation updates of the product.

The other thing is that, no matter who answers what, you need to test this on a sacrificial server before moving it to production or even a dev box. We have Dev, Staging/UAT, and Prod boxes in our environment. The easiest one to rebuild is Staging/UAT because it's identical to prod and having a problem there would be the easiest to recover from. Having a problem in Dev would be (no pun intended) devastating because of the number of projects being developed. It would be even more difficult to recover than prod. Of course, you don't want the first upgrade to be in prod, either.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

Just reinforcing what Jeff said. The single most important thing you can do, after contacting ESRI directly, is to test this process. Do not assume that anything we tell you or anything ESRI tells you is so. Test it. Safely. In a non-production environment. If you don't have one, set on up. This is about protecting the business and is as important as backups. By the way, be sure you test your backups before attempting this in production too.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Quinn-793124 SSCrazy Points: 2785 More actions · Answer 4

Hi,

I talked to ESRI they weere a little help. They said to dot he command select @@versions which told me what verion I was on SQL Server 2008 r2 but I already knew that.

Is there a way a way to figure out what license level I am at? Like express, standard or enterpriseso I get the same license level?

Thanks much

Quinn

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 5

Quinn-793124 (7/27/2016)
Is there a way a way to figure out what license level I am at? Like express, standard or enterpriseso I get the same license level?

SELECT SERVERPROPERTY('Edition')

John

Quinn-793124 SSCrazy Points: 2785 More actions · Answer 6

Thanks much John. That worked great.

You guys are great.

Q