sql 2008 to sql 2016

• Davekahn

  SSCommitted

  Points: 1840

  More actions

  January 30, 2018 at 6:56 pm

  #328733

  Hi all, 
  I need to migrate couple of DB's of SQL 2008 to SQL 2016 
  there is a replication setup between old servers 
  Just need to know if there are any benefits of using Always on instead of replication
  I need to create a pros & cons kind of document for the department 

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 31, 2018 at 3:13 am

  #1978008

  Availability Groups is a HA solution. The secondaries are up to date with the primary, but either inaccessible or read only

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• subramaniam.chandrasekar

  SSCarpal Tunnel

  Points: 4223

  More actions

  February 1, 2018 at 8:06 am

  #1978202

  qew420 - Tuesday, January 30, 2018 6:56 PM

  Hi all, 
  I need to migrate couple of DB's of SQL 2008 to SQL 2016 
  there is a replication setup between old servers 
  Just need to know if there are any benefits of using Always on instead of replication
  I need to create a pros & cons kind of document for the department 

  Thanks

  there are some difference b/w replication and always on features. I'd like to know any dependent systems those have been pulling data from your team ?