1

What is the difference between Data Sync and Standard Geo Replication on SQL Azure databases?

I understand that Active Geo Replication provides the ability to connect to a replicated database whereas Standard does not allow connections. However, how does Data Sync differ? I know it's not immediate replication, but I need to point my BI software to a replication and am debating which configuration I use for replication and disaster recovery.

joeldow
  • 1,048
  • 1
  • 9
  • 19

1 Answers1

0

Data Sync allows you specify what to sync (e.g., which tables), specify sync interval (e.g, 5mins, 15mins), replicas are read/write and allows you to specify how to resolve conflicts (e.g., hub wins, client wins), databases can exists independent of other databases.

JuneT
  • 7,840
  • 2
  • 15
  • 14