1

For example, if I have a database in North America and replicate it in Europe, will a European user automatically connect to the replicated database in Europe?

Ryan R. Rosario
  • 5,114
  • 9
  • 41
  • 56
konrad
  • 11
  • 1

1 Answers1

1

Short answer: No.
Long answer: If you use Active Geo-Replication you can use replica DB for reads (only), but it won't magically happen on its own.
What you have to do - implement some logic on your application to forward requests to the appropriate DB (or if its a WebApp, provide different connection strings to different instances of your WebApp).

Further reading: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview

4c74356b41
  • 69,186
  • 6
  • 100
  • 141
  • Exactly, the connection strings are different for the replicas. You could think of them as separate databases, just with a replication set up between them. – juunas Jan 06 '17 at 07:33