SQL Azure Data Sync Feature Voting on UserVoice

allow tables with circular references to sync [is now completed]

2012-02-01T07:44:11-08:00

allow tables with circular references to sync [updated]

2012-02-01T07:44:11-08:00

Mark Scurrell (admin) responded:

Thanks for the feedback. The service now supports self-referencing tables as of the service update at end Jan'12.

Provide API’s to configure, manage and initiate sync [is now planned]

2012-02-01T07:43:07-08:00

Allow on-premises or cloud-based applications to configure sync groups and initiate syncs.

Provide monitoring API’s [is now planned]

2012-02-01T07:42:48-08:00

Provide a REST API to allow synchronization status to be monitored programmatically. For example, current status of all Sync Groups to determine if syncs are succeeding or failing for any reason.

Support for tables for which primary key is different than Clustered index [updated]

2012-01-25T04:17:27-08:00

In a lot of situations the Clustered index differs from the primary key in a table. At this moment, Data Sync supports only tables for which the clustered index is the primary key. It would be nice if this restriction is not needed. This will make live much easier to sync data between on-premise and SQL Azure db. We can't change current datamodel in our application. Current datamodel is made based on performance.

Stevo said:

Absolutely, on one hand you suggest having Guids as PKs and removing the clustered index from them, on other hand this is not supported on Data Sync.

http://social.msdn.microsoft.com/Forums/nl-NL/ssdsgetstarted/thread/7e58f132-2b58-4554-9033-1e9745a2d61d

Seems like it is impossible to have a combination of Sql Azure + Federations + Data Sync that actually performs. (Assuming Data Sync will ever support Federations)

Support files and Windows Azure Blobs [updated]

2012-01-20T14:10:13-08:00

Add synchronization capabilities for the Windows Azure Blob Service. Allow data to be synchronized between storage accounts and allow on-premises file data to be synchronized with the Blob Service.

Bart X. Tubalinal said:

This should be possible with the Sync Framework. This link is old but should still be applicable: http://blogs.msdn.com/b/sync/archive/2009/12/03/synchronizing-files-to-windows-azure-storage-using-microsoft-sync-framework.aspx

Support for different on-premises databases [updated]

2012-01-20T14:04:02-08:00

On-premises SQL Server databases can currently be included in a Sync Group. Would you like support for other databases; if so, which ones?

Bart X. Tubalinal said:

Oracle

Sync local sql data base with federated sql azure data bases

2012-01-20T01:53:23-08:00

Set up sync without altering on-premise database

2012-01-20T01:31:31-08:00

Joel Sanderi suggested:
Instead, the sync information could be held in a separate database on the same server. This would be great for syncing system critical databases like the SCCM database.

Provide API’s to configure, manage and initiate sync [updated]

2012-01-18T06:27:10-08:00

Allow on-premises or cloud-based applications to configure sync groups and initiate syncs.

Stuart Kelly said:

The ability to initiate syncs would be extremely valuable for occasionally connected clients.

Support for different on-premises databases [updated]

2012-01-17T00:20:42-08:00

On-premises SQL Server databases can currently be included in a Sync Group. Would you like support for other databases; if so, which ones?

Stuart Kelly said:

On premise SQL Compact Edition..

Support for different on-premises databases [updated]

2011-12-29T13:59:09-08:00

On-premises SQL Server databases can currently be included in a Sync Group. Would you like support for other databases; if so, which ones?

P Velachoutakos said:

It can be done , be provisioning manual the other database ,and use custom sync providers.It is difficult task especially when have lot of tables but the Sync SDK support it.(The sync not the provisioning,provisioning must be done manually on other ado.net database mysql,oraclle etc.)
Off course this not supported with the sync server only for sync sdk managed code.

Sync Group configuration can be updated to cater for database schema changes [is now planned]

2011-12-05T20:20:19-08:00

Allow Sync Group configuration to be updated when there have been schema changes, such as a new table or new column added, without re-creating the Sync Group.

allow tables with circular references to sync [is now started]

2011-12-05T20:16:37-08:00

allow tables with circular references to sync [updated]

2011-12-05T20:16:37-08:00

Mark Scurrell (admin) responded:

Thanks for the feedback; this will be fixed for the final release.

Let me configure that deletes are not synced

2011-12-05T08:50:56-08:00

Mark Scurrell suggested:
For some scenarios data is collected and updated in one database and needs to be transferred to another database, one way. I want the ability to delete data from the source database after a certain time period and it has been synced, without those deletes being synced. Allows me to aggregate data from one or more locations.

Allow bulk insert when first populates data to target database [updated]

2011-11-24T20:36:04-08:00

It took over 10 hours to move 6GB of data to target database on the first synchronization. When I used SQLAzureMW, it took less than hour.

Sunil said:

Then how will you handle the _Tracking tables after first sync (Using SQLAzureMW) because in the next sync it will again go for the Full table sync.

Allow bulk insert when first populates data to target database [updated]

2011-11-24T20:31:53-08:00

It took over 10 hours to move 6GB of data to target database on the first synchronization. When I used SQLAzureMW, it took less than hour.

Sunil said:

I am getting the Same Issue :

Synchronization took approximate 17 Hrs to on the first Synchronization, Total number of records moved to Cloud DB was 1305538.

Here is the Table Info :

Number of Columns 184
Row Size in in Byte 234181

_Tracking Tables

2011-11-24T20:18:15-08:00

Sunil suggested:
No need to create a _Tracking table in case the Database is read only. This will improve the performance of Data Sync.

Support for different on-premises databases [updated]

2011-11-17T03:00:36-08:00

On-premises SQL Server databases can currently be included in a Sync Group. Would you like support for other databases; if so, which ones?

Anoushka said:

I would like the SQL Azure Data Sync Services to include on premise member database as Oracle or MySQL database

don't touch/modify my schemas [updated]

2011-11-08T09:59:50-08:00

I don't want the data sync or anything else for that matter to "touch" any of my databases.

Jason R. Craig said:

I fully agree, that is why Microsoft SQL Server 2008 has change tracking.

Allow taking a database offline to prevent charges to my account.

2011-11-04T18:37:49-07:00

Lars Kemmann suggested:
it would be nice if Windows/SQL Azure subscriptions would support "deactivating" a service or database, respectively. I would like to be able to store these things (perhaps in my Azure storage account, or in my Windows Live SkyDrive) with the ability to bring them back online at a later date. This way, I incur less overhead when there are long periods where I don't need my services running and I don't want to incur charges on my subscription.

Sync SQL Server with Windows Azure Tables

2011-11-02T20:30:55-07:00

Mark Scurrell suggested:
You want to use Windows Azure Tables for your application in the cloud as opposed to SQL Azure Database, but need to sync with on-premises SQL Server. Provide the sync between the two different stores with some sort of mapping specified.

don't touch/modify my schemas

2011-11-01T22:03:34-07:00

an anonymous user suggested:
I don't want the data sync or anything else for that matter to "touch" any of my databases.

allow tables with circular references to sync [updated]

2011-10-20T16:30:27-07:00

James Backert said:

Right now I have a table that represents a hierarchy. None of the tables make a complete circle reference, but the table does have a foreign key to itself. This seems like the best way to establish a hierarchy and should be supported

Off line Sync feature [updated]

2011-10-19T22:04:59-07:00

Feature to sync between two database, once they are connected to net or by moving some files to other machine and sync with othere database

hitesh said:

will help to small company and maketing people...

Mail notification [updated]

2011-10-19T22:03:16-07:00

support team should get mail notification on failure with required action to be taken to resolve it

hitesh said:

this will help to support team to take action immediately

Mail notification

2011-10-19T22:02:31-07:00

hitesh suggested:
support team should get mail notification on failure with required action to be taken to resolve it

Off line Sync feature

2011-10-19T22:00:44-07:00

hitesh suggested:
Feature to sync between two database, once they are connected to net or by moving some files to other machine and sync with othere database

Spatial data support [updated]

2011-10-19T15:32:15-07:00

Allow spatial data type columns to be synchronized.

SW said:

I'd vote 10 on this if I could.

Support iPhone syncing [is now none]

2011-10-11T07:18:59-07:00

Support iPhone <-> SQL Azure or Azure table syncing

Add client side support for Silverlight [is now none]

2011-10-11T07:18:03-07:00

Online and Offline syncing. File system and Isolated storage support. Make it extensible and provide source code with public review. Just like ASP.NET MVC project.

Automatic propagation of schema changes to one database to all databases in a sync group

2011-10-11T07:14:58-07:00

Mark Scurrell suggested:
In addition to allowing Sync Group configuration to be updated to cater for schema changes, automatically propagate the schema changes to all databases in a Sync Group.

Sync Group configuration can be updated to cater for database schema changes

2011-10-11T07:14:35-07:00

Mark Scurrell suggested:
Allow Sync Group configuration to be updated when there have been schema changes, such as a new table or new column added, without re-creating the Sync Group.

Provide API’s to configure, manage and initiate sync

2011-10-11T07:14:12-07:00

Mark Scurrell suggested:
Allow on-premises or cloud-based applications to configure sync groups and initiate syncs.

Provide monitoring API’s

2011-10-11T07:13:47-07:00

Mark Scurrell suggested:
Provide a REST API to allow synchronization status to be monitored programmatically. For example, current status of all Sync Groups to determine if syncs are succeeding or failing for any reason.

Support files and Windows Azure Blobs

2011-10-11T07:13:22-07:00

Mark Scurrell suggested:
Add synchronization capabilities for the Windows Azure Blob Service. Allow data to be synchronized between storage accounts and allow on-premises file data to be synchronized with the Blob Service.

Support Windows Azure Tables

2011-10-11T07:12:20-07:00

Mark Scurrell suggested:
Add synchronization capabilities for the Windows Azure Table Service. Allow data to be synchronized between storage accounts and allow on-premises data to be synchronized with the Table Service (from which on-premises stores?).

Support for different on-premises databases

2011-10-11T07:09:04-07:00

Mark Scurrell suggested:
On-premises SQL Server databases can currently be included in a Sync Group. Would you like support for other databases; if so, which ones?

Spatial data support

2011-10-11T07:07:41-07:00

Mark Scurrell suggested:
Allow spatial data type columns to be synchronized.

Add Windows Mobile support [is now none]

2011-10-11T07:07:11-07:00

Add support for devices running Windows Mobile 6+, don't wait for WM7.

Ability to sync data from one SQL Azure data center to another [is now none]

2011-10-11T07:07:06-07:00

Ability to provide geo-replication of data across data centers where data is available in data centers closest to the end users.

Provide admin interface simillar to merge replication. [is now none]

2011-10-11T07:06:30-07:00

Currently the sync framework does not have any admin interface, to monitor the sync activity. This feature would be usefull for monitoring the sync activity.

Provide more meaningful error message

2011-06-20T22:11:13-07:00

Bunbv suggested:
To be helpful on problem investigation.

Allow bulk insert when first populates data to target database [updated]

2011-06-20T22:08:17-07:00

It took over 10 hours to move 6GB of data to target database on the first synchronization. When I used SQLAzureMW, it took less than hour.

Bunbv said:

It would be nice if we can snapshot data on first synchronization.

Allow bulk insert when first populates data to target database

2011-06-20T22:05:44-07:00

Bunbv suggested:
It took over 10 hours to move 6GB of data to target database on the first synchronization. When I used SQLAzureMW, it took less than hour.

Reconfigurable Scopes. Allow adding tables and changing filters of existing Scope. [updated]

2011-06-20T21:48:56-07:00

Currently Scopes can not be changed once created. Changing the filter on a scope should sync any additional rows automatically.

Bunbv said:

Allow to add or remove tables on existing sync group. I don't want to recreate new sync group and push data of existing tables again.

Ability to extend databases (other than SQL Server) to SQL Azure - Please list database in comments [updated]

2011-04-28T09:20:33-07:00

yogaguy74 said:

Oracle 10/11

Support for tables for which primary key is different than Clustered index

2011-04-28T08:44:08-07:00

André van de Graaf suggested:
In a lot of situations the Clustered index differs from the primary key in a table. At this moment, Data Sync supports only tables for which the clustered index is the primary key. It would be nice if this restriction is not needed. This will make live much easier to sync data between on-premise and SQL Azure db. We can't change current datamodel in our application. Current datamodel is made based on performance.

Add Sql Server Express ClientSync for Hub And Spoke Sync [updated]

2011-03-12T06:10:46-08:00

Add Sql Server Express ClientSync for Hub And Spoke Sync

Edmund said:

Add Sql Server Express ClientSync for Hub And Spoke Sync