x

Database server upgrade

All,

Currently, i am using SQL SERVER 2008 Standard in our organisation. I wonder what factors should i consider to upgrade it to sql server 2008 r2? In other words, what factors drive in an organisation that enables us to think about upgrading a existing version of the database server.

Thanks,
more ▼

asked Nov 16 '11 at 06:42 PM in Default

Katie 1 gravatar image

Katie 1
1.4k 129 163 202

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Regardless of the version you want to upgrade to, take a look at what features you currently use and what features are coming in the version you want to upgrade to. Take into consideration if there are any features that you currently miss, but are in the next version. Also consider if the Edition will stay the same or not (upgrade/downgrade).

Some Enterprise only features of a current version get pushed down to Standard Edition (backup compression being a good example for 2008R2).

I agree with @Håkan Winther, wait and upgrade to 2012. That is, if you can wait and if the new licensing plans don't clash with your company's policies.
more ▼

answered Nov 16 '11 at 11:46 PM

WilliamD gravatar image

WilliamD
25.8k 17 19 41

@william and how does the licencing work, is there a chance, you give me some ballpark figure of the cost involved in an upgrade? I know i should be calling microsoft. But trying to get a sense of the money involved the effort, if you had any experience doing it.
Nov 17 '11 at 04:51 AM Katie 1

I'm afraid that is a difficult subject. I work for a large company with a licensing contract with MS, so we pay different prices compared to other companies.

If you don't have a contract with MS, you would need to speak to them directly or look at pricing from 3rd party resellers.
Nov 17 '11 at 05:01 AM WilliamD
Brent Ozar and Denny Cherry have some good articles on the pricing changes.
Nov 17 '11 at 06:35 AM Shawn_Melton

@Shawn_Melton - there is no doubt some great info out there on the upcoming pricing changes with 2012. However, not everything there will be applicable to everyone. MS pricing policies are a mess at best. There are multiple possible prices for the same product, depending upon your/your company's affiliation/contracts with MS.

With that in mind, @Katie 1 is probably best off talking to an MS representative about what is possible and what it will cost.
Nov 17 '11 at 06:40 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
Personally I would wait for SQL server 2012. SQL server 2012 contains a lot more features that are useful and SQL server 2012 is scheduled to the beginning of 2012.
more ▼

answered Nov 16 '11 at 09:41 PM

Håkan Winther gravatar image

Håkan Winther
15.5k 33 37 48

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x672
x562
x84
x68

asked: Nov 16 '11 at 06:42 PM

Seen: 847 times

Last Updated: Nov 16 '11 at 06:42 PM