r/AZURE•
WeatherFluffy9769

Data replication from prod to read replicate in Azure SQL MI

Database

I am in middle of finalizing database for our company. Though I have gone through multiple readings but there are couple of questions which i am still confused at. We are planning to go ahead with Azure SQL MI (Business Critical) approach

  1. My understanding is that BC Tier comes with read replica, is it true?
  2. How does the replication happens between a prod instance and read replica, does this need to be manually managed or gets auto-taken care of by azure platform.
  3. The plan is to use read replica for all the reporting use-caess. Is this correct approach?
  4. What if there is data that needs to be imported from different data sources (could be sql, could be something else). Should those be inserted in prod instance and will get replicated to read replica? (this data is only needed for reporting)

Thanks

Posted May 4, 2022, 2:01 AM UTC

21
Loading comments…