asked
High availability from 2014 to 2012
Hi, Any body can advise me, how can I proceed the high availability(Replication or Mirroring) on SQL server 2014 to SQL Server 2012. If possible to do High availability, let me know the steps to proceed. Regards Murali
you may mirror or replicate from 2012 to 2014 but not from 2014 to 2012. Ideally, all instances involved in the topology should be the same SQL Server version
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
Avoid mirroring as it is going to go away at some point in the future. Additionally you cannot go from a higher version of SQL Server to a lower version for mirroring nor log shipping. About your only options are to upgrade the lower version of SQL to be equal to the higher version of setup replication. One key element to keep in mind for replication is that every table that is to be replicated must have a primary key on it.
20 People are following this question.
