Migration

• ramana3327

  SSCoach

  Points: 19700

  More actions

  August 26, 2014 at 12:41 pm

  #292619

  Hi All,

  We are planning to upgrade. We are using Sql 2008R2 now. Which is the better option migrating to SQL 2012 or migrating to 2014?

  I am thinking 2014 has memory optimized tables and updatable column stored index. So it is better option.

  Any suggestions please

  Thanks

• caffeinated

  Ten Centuries

  Points: 1271

  More actions

  September 1, 2014 at 1:13 am

  #1742156

  This is a very broad question that depends on your business, resources, staff, infrastructure, etc.

  This link might help:

  http://www.mssqltips.com/sqlservertip/3248/choosing-between-sql-server-2012-and-sql-server-2014/

• Vimal Lohani

  SSCommitted

  Points: 1650

  More actions

  September 1, 2014 at 1:27 am

  #1742159

  ramana3327 (8/26/2014)

  ---

  Hi All,

  We are planning to upgrade. We are using Sql 2008R2 now. Which is the better option migrating to SQL 2012 or migrating to 2014?

  I am thinking 2014 has memory optimized tables and updatable column stored index. So it is better option.

  Any suggestions please

  Thanks

  Migrating to higher is a good option, How ever you have to consider all effects of this.

  Are you upgrading the services or using new database of higher version.

  Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature