x

SQL SERVER MIGRATION

Hi Experts , I am a small company and we are using" Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) " we are planing to Upgrade our server .what SQL SERVER Version will suitable for small company?

more ▼

asked Jan 09 at 02:31 PM in Default

avatar image

shamim007
80 4

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

4 answers: sort voted first

I would advise you to use SQL Server 2016 Standard SP1.

This is the latest version. You can only purchase the latest version, (but run earlier versions in a downgrade scenario) so why not have the ability use the all the new features?

Whatever version you choose, make sure that you check for any deprecated features that you might be using in SQL 2008 R2.

https://msdn.microsoft.com/en-us/library/bb677622.aspx

more ▼

answered Jan 09 at 02:39 PM

avatar image

Kev Riley ♦♦
64.8k 48 62 81

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

The version you will need to upgrade to is one that all the connecting application support. Typically you can only purchase the latest version from MS (currently 2016), but they are backwards compatible (always check with a licensing expert - as I am not). Contact all your vendors to see if there application support 2012/2014/2016, as that may make your decision easy.

That said, if you go with SQL 2016 SP1 then Microsoft have opened up a number of what used to be enterprise features (see here) in the standard edition.

more ▼

answered Jan 09 at 02:50 PM

avatar image

sp_lock
10.6k 27 37 37

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

I agree with the above two comments (go for SQL 2016) but consider the following points make sure that if any of the application/s that you are supporting is compatibility preference.

more ▼

answered Jan 11 at 08:56 AM

avatar image

alemgeb
0

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

As new features added to SQL Server 2016. So its good to use updated features. Here, you can see how to Upgrade to SQL Server 2016 in an Effective Way:

more ▼

answered Jan 11 at 06:48 AM

avatar image

jason_clark03
307 3 7

(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.

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:

x2112
x82

asked: Jan 09 at 02:31 PM

Seen: 55 times

Last Updated: Jan 11 at 08:56 AM

Copyright 2016 Redgate Software. Privacy Policy