Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon

Microsoft announces general availability of Azure SQL Data Sync

Save for later
  • 2 min read
  • 22 Jun 2018

article-image

The Azure team at Microsoft were highly excited to release the general availability of Azure SQL Data Sync tool for synchronization with their on-premises databases. This new tool allows database administrators to synchronize the data access between Azure SQL Database and any other SQL hosted server or local servers, both unidirectionally and bidirectionally.

This new data sync tool allows you to distribute your data apps globally with a local replication available in each region, keeping data synchronization continuous across all the regions.

This tool would help to significantly eradicate the connection failure and eliminate the issues related to network latency. It will also boost the response time of the applications and enhance the reliability of the application run time.

Features/Capabilities of Azure SQL data Sync:

  • Easy-to-Config - Simple and better configuration of database workflow with exciting user experience
  • Speedy and reliable database schema refresh - Faster loading of database schemas with new Server Management Objects (SMO) library
  • Unlock access to the largest independent learning library in Tech for FREE!
    Get unlimited access to 7500+ expert-authored eBooks and video courses covering every tech area you can think of.
    Renews at €18.99/month. Cancel anytime
  • Security for Data Sync - End-to-end encryption provided for both unidirectional and bi-directional data flows with GDPR compliance.


However, this particular tool would not be a true friend to DBAs as it does not support disaster recovery task. Microsoft has also made it very clear that this technology would not be supporting scaling Azure workloads, nor the Azure’s Database Migration Service.

Check out the Azure SQL Data Sync Setup documentation to get started. To know more details, you can refer to the official announcement at official Microsoft web page.

Get SQL Server user management right

Top 10 MySQL 8 performance benchmarking aspects to know

Data Exploration using Spark SQL