SQL Data Sync SU5 has been released!

re: SQL Data Sync SU5 has been released!

JuneT — Tue, 31 Jul 2012 03:44:10 GMT

@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.

re: SQL Data Sync SU5 has been released!

Guy B — Fri, 27 Jul 2012 12:57:36 GMT

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.

re: SQL Data Sync SU5 has been released!

Shirley Wang [SQL] — Tue, 12 Jun 2012 03:49:06 GMT

Hi Nick, version 4.0.46.0 is a higher version than 4.0.5.0. The v4.0.5.0 agent has expired on Jun 08 23:59:59 UTC time, and you should now be able to upgrade to the latest v4.0.46.0 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?

re: SQL Data Sync SU5 has been released!

Russ — Mon, 11 Jun 2012 13:27:00 GMT

When will circular foreign key references be supported?

social.msdn.microsoft.com/.../02766122-c785-4a2e-bf2f-09b3e50f1c44

re: SQL Data Sync SU5 has been released!

NickR-HMS — Fri, 08 Jun 2012 09:12:10 GMT

You version numbers have gone backwards. The one I installed about a week ago is version 4.0.5.0 and the update client is disabled! What do I do? Remove and re-install?