Using SQL Azure Data Sync Service to provide Geo-Replication of SQL Azure databases

The Discussion

• 

  Nice video, thanks! But what about conflict management. What if someone in europe changes the same customer as in the US? How do you handle this?
  Can you also synchronize to mobile devices? And what about filtering? For example: I only want to send VIP customers to europe. Is this possible?
  Thanks,
  Bas

• 

  Yes, SQL Azure Data Sync does support conflict handling and automatically resolves any conflicts for you.  As for filtering the only level of filtering currently available is at a table level (meaning you can choose to sync only specific tables).  Over time we will add more filtering down to the level of rows and columns.

  Liam

• 

  Liam, awesome demo, thanks!

  >Yes, SQL Azure Data Sync does support conflict handling and automatically resolves any conflicts for you

  Do you have the rules on how conflicts are handled listed anywhere?  Here's an example -

  - Suppose three databases in a sync group: NorthCentral US (HUB), Europe (Member), and Southeast Asia (Member).

  Here are some scenarios -

  - Update record in Asia, Update same record/same field in Europe, sync, check records in asia, europe, us - last change (Europe) should win?

  - Delete record US, update same record in Europe, sync, check records in asia, europe, us - the deletion should win? Even if it happened before the update in Europe?

  - Add field to table in US, sync, check schema changes are made in Asia, Europe - are schema changes sync'ed?

  - Add table to US, sync, check schema changes are made in Asia, Europe - same question on schema changes.

  Emmanuel