Covering SQL Azure Data Sync and Microsoft Sync Framework
SQL Azure Team Blog
Sync Framework Developer Center
JuneT - Idle Thoughts
Liam's Cloud Data Service Blog
The latest Service Update 5 has just been released! SU5 delivers 2 major features designed to improve sync experience:
SU5 also includes various fixes that provide better usage experience to our customers. To be consist with the rest of Windows Azure services, the new branded name is now SQL Data Sync.
You can download the latest local agent (v18.104.22.168) from the download page now.
You version numbers have gone backwards. The one I installed about a week ago is version 22.214.171.124 and the update client is disabled! What do I do? Remove and re-install?
When will circular foreign key references be supported?
Hi Nick, version 126.96.36.199 is a higher version than 188.8.131.52. The v184.108.40.206 agent has expired on Jun 08 23:59:59 UTC time, and you should now be able to upgrade to the latest v220.127.116.11 SU5 agent.
Hi Russ, supporting tables with circular foreign key dependencies is relatively low priority compared to other features we are contemplating on, such as providing configuration, control, and monitoring APIs. How much of a blocker is this for you to use SQL Data Sync?
I have spent the last week trying to get SQL Data Sync SU5 to work with SQL Server 2012 and Spatial Types. I think there must be some dependencies missing from the prerequisites. I installed everything as described and made sure all my projects were using target platforms of x86 yet I repeatedly got an exception that a Com object was not registered.
I managed to track down the com objects dll "C:\Program Files (x86)\Microsoft SQL Data Sync\bin\Synchronization214.dll" and register it using regsvr32. After this I then got exceptions trying to convert HierarchyID to byte. I have implemented a workaround for HeirarchyIDs, but I was hoping to remove it with this version of SQL Data Sync. It seems the tool is far from ready or that there are missing prerequisites. If I remove the HeirarchyIDs from the tables the sync works fine. Provisioning the server and client works, just the synchronize() call fails.
Can a DataConverter be used to solve the issue?
I am running on Windows 7 Professional x64 and both the server and client DBs exist on a local instance of SQL Server 2012.
Any help would be appreciated.
@Guy B - are you using SQL Azure Data Sync Service or Sync Framework? the SQL Azure Data Sync service introduce support for spatial data but its not in Sync Framework yet.