1

I want few recommendations while considering azure vs aws for our current database which is SQL Server 2012 standard edition. Currently we are using AWS RDS for managing our database, recently we had been considering active read replica for our heavy prod database, but it seems like aws doesn't have read replica option for MS SQL Server , but only CDC(change data Capture ) option , that doesn't solve our needs because CDC involves manual loading of every other thing except for tables and their primary indexes, whereas for Aurora or mySQL , they have proper read replica options. Hence we want to know if MS Azure will be better for us in this case.

Thanks in advance!

closed as off-topic by Shanky, Tom V, wBob, MDCCL, Lennart May 18 '18 at 17:52

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Shanky, Tom V, Lennart
If this question can be reworded to fit the rules in the help center, please edit the question.

2

With Azure SQL Database you have the option of Geo-Replication. Active geo-replication enables you to configure up to four readable secondary databases in the same or different data center locations (regions). Secondary databases are available for querying and for failover if there is a data center outage or the inability to connect to the primary database. The failover must be initiated manually by the application of the user. After failover, the new primary has a different connection end point. You can learn more about this Azure SQL Database feature here.

  • I agree that if you want these awesome features go Azure. Just keep in mind it is SQL 2017 not SQL 2012. But you should go there anyway. – Nick.McDermaid May 18 '18 at 21:24

Not the answer you're looking for? Browse other questions tagged or ask your own question.