Maybe I'm searching for the wrong thing, but I can't see how I can do this.
I have two servers:
- Server A (has SQL Server 2012 installed)
- Server B (has SQL Server 2014 installed)
Server A provides an API via IIS. The code both inserts and gets data from the database depending on the API call.
Server B does exactly the same for its local database.
I would like to have it so that the two databases are consistent copies of each other. I do believe this is what HA accomplishes.
So a load balancer, for example, might direct API calls to A sometimes, and B sometimes, but the data needs to be consistent either way.
I found some documentation on HA for SQL Server 2012, but not on how to do this for a mixed environment of 2012 and 2014.
Any help or pointers to documentation would be great! Thanks.