Azure VMs - Upgradeing from SQL 2008 R2 to SQL 2014, side by side

• ankithimmatlalshah

  Ten Centuries

  Points: 1090

  More actions

  August 21, 2015 at 3:16 am

  #319977

  Hello everyone,

  We're planning to upgrade our existing setup from SQL 2008 R2 to SQL 2014 at Azure.

  The new server is up and running with SQL 2014.

  Now, my job is to move all databases and SQL jobs to this new server.

  Then, test command line database build and convert all existing SSIS Packages.

  Once I prepare this server, the next task is to prepare 2 QA servers in a similar manner.

  And finally, the production server.

  Can anybody please advise what needs to be taken care to complete this job successfully?

  Also, please advise how to prepare the templates or scripts, which could be reused for other servers down the line.

  Likewise, please suggest how to get the maximum benefits/advantages of SQL 2014 at Azure?

  Like,

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/09/25/using-ssds-in-azure-vms-to-store-sql-server-tempdb-and-buffer-pool-extensions.aspx

  Any help would be greatly appreciated.

  Thanks,

  Ankit

• Grant Fritchey

  SSC Guru

  Points: 398679

  More actions

  August 21, 2015 at 12:32 pm

  #1821775

  Please don't cross post questions. It just confuses the conversation.

  Please post responses to this question over here.

  "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