• Perry Whittle (1/28/2015)


    muthukkumaran Kaliyamoorthy (1/28/2015)


    Yes, Correct. Server A & B old - SQL 2012. And need to move it to server C & D new - SQL2014.

    So, you have two options

    The first option involves joining ServerC and ServerD to the same Windows Server Failover Cluster as ServerA and ServerB.

    You then restore a backup of the large database onto C and D and then join the instances to the same Availability group as A and B. Once the database has synchronised you failover the group to either C or D and the database is at SQL Server 2014.

    To clean up you remove A and B from the AlwaysOn group and then if necessary remove the servers from the Windows Server Failover Cluster.

    The second option involves setting up C and D in a new Windows Server Failover Cluster (which it sounds like you may have already done) and creating a cross cluster migration. There is a document provided by Microsoft on how to achieve this, you can find it at this link.

    Thanks Perry for your input and assistance. I have not heard cross cluster AG migration.

    I am going with option 2. Since it's already a GEO cluster 4 node in USA (6 SQL instances)+ 2 node in China (2 SQL instances).

    My plan is to migrate the 2 named instance in USA from WSFC 2008+ SQL2012 to WSFC SQL2014.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/