Post reply

sql 2008 to sql 2016

  • 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

  • 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

  • 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 ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply