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/