Updated: July 23, 2020 (September 11, 2018)

Azure SQL Data Sync Released

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

Azure SQL Data Sync can help organizations share data and ensure remote users have the latest information for reports and analysis.
The service is designed for creating distributed applications, but it lacks important management features.
SQL Data Sync uses Azure SQL Database, introducing database hosting and data movement costs.

Azure SQL Data Sync is a Microsoft-hosted hub service for data synchronization across multiple databases. It uses Azure SQL Database to synchronize data between a central master database and one or more remote databases. It can help organizations create distributed applications where data needs to reside locally for latency or reliability. However, the service brings new cost and has limitations that could prevent its use for complex applications.

Overview

With SQL Data Sync, customers can synchronize an entire database or specific tables and columns. Customers can also control the frequency of updates to meet refresh needs and control performance. Potential use cases for SQL Data Sync include the following:

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now