<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d8211560\x26blogName\x3dTech+Tips,+Tricks+%26+Trivia\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttps://mvark.blogspot.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttp://mvark.blogspot.com/\x26vt\x3d601588505461698440', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Tech Tips, Tricks & Trivia

by 'Anil' Radhakrishna
An architect's notes, experiments, discoveries and annotated bookmarks.

Search from over a hundred HOW TO articles, Tips and Tricks

Azure SQL Data Sync - soon to be out of Preview mode

Interesting facts about Azure SQL Data Sync from blog posts & comments to articles -

Azure SQL Data Sync has been in Preview mode since 2012. Gmail which was launched on April 1,2004 as an invitation-only e-mail service officially exited its beta status on 7 July 2009 - after 5 years

Azure SQL Data Sync can be used to implement the data distribution between on-premises SQL Server, Azure SQL VM and Azure SQL databases, in uni-direction or bi-direction.

A Sync Database is a customer owned Azure SQL Database located in the same region as the Sync Group which stores metadata and logs. One Sync Database can be used for many sync groups in the same region.

SQL Data Sync is only for SQL Server and Azure SQL Database. All versions after SQL Server 2008 are supported. SQL Express is planned to be officially supported when the product becomes Generally Available (GA)

SQL Data Sync supports an automatic scheduled Sync. 5 minutes is currently the smallest frequency.

SQL Data Sync can be used with PowerShell and REST APIs

SQL Data Sync only allows you to sync between Azure SQL Databases in the same Subscription.

To workaround performance issues when database grows in records, currently you can create multiple sync groups to sync different tables in the same database.

The 32 bit version of the Data Sync 2.0 Agent will work with the 64 bit version of SQL Server.

Also see - What do CTP, RC, RTM, RTW mean?

Labels: , ,

Tweet this | Google+ it | Share on FB

« Home | Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »


Post a Comment