I've been looking at the new features of SQL 2012, and how it can help my current situation.
Currently we're on SQL 2008R2, and replicate two OLTP servers' databases to a single reporting server via transactional replication. We then use these replicated DBs for reporting.
I'm interested in whether SQL 2012 and the Availability Groups can replace this - So instead of transactional replication, I'd use the new availability groups and mirror the two OLTP servers' databases to the reporting server - Where the reporting will be able to access the read-only replicas.
I'm unsure if this will work well, or even at all.
I would like to get away from replication, as it causes issues with my deployment strategy (Using VSDBCMD.exe). I'd also like to get away from replication reinitialisation delays on large DBs.
Does anyone have any good examples or experience with this? Is it possible to mirror with readable replicas from multiple servers to a single server as per normal mirroring in lower versions?
This was originally asked here: http://stackoverflow.com/questions/10415225/mirroring-and-availability-groups-in-sql2012 Sorry I don't think I can migrate questions yet.