SQL Data Sync

Azure SQL Data Sync (Preview) is a service that enables you to synchronize the data you select across multiple SQL Server and SQL Database instances. To synchronize your data you create sync groups which define the databases, tables and columns to synchronize as well as the synchronization schedule. Each sync group must have at least one SQL Database instance which serves as the sync group hub in a hub-and-spoke topology.

If you have any feedback on Azure SQL Data Sync service, we’d love to hear it.

  1. SQL Data Sync API to manually trigger a sync

    We need a way to force a sync. With the minimum sync window of 5 mins we cannot guarantee prevention of data contention. For example, in a bookings system, the on premises database is always 5 mins out from potential web updates. Maintenance users want to add exclusions or blocks and need to know no new bookings were made in those slots. Likewise, if the on premises database makes entries, it needs to force those entries immediately to the web and not wait for the Sync. We see this as an important architectural requirement to an otherwise impressive service.

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Off line Sync feature

    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

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Shirley Wang responded

    This is an interesting idea – allowing source to turn on change tracking, but not requiring the sync group to be persisted but rather the sync relationship established dynamically.

  3. What happened to Sync Preview for SQL Databases in the new portal?

    I can no longer figure out how to access the Sync for SQL Azure Databases. This needs to be put into the new portal so it can be found without going back to the old one.

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Support for different on-premises databases

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

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Provide more meaningful error message

    To be helpful on problem investigation.

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support change data capture

    Instead of trigger based loads, Support Change data capture as a way to identify changes to a table.

    We currently use CDC for incremental loads to our data warehouse, Adding triggers and tables to support Data Sync duplicates this information.

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Keep Sync

    Amazingly powerful SQL Sync Tool in Azure -- easy to use and well done. I'd like to vote to move it out of Preview and into the Standard features as this is going to be a great selling point to Azure SQL. The only hesitation I have to using it more is because it has a warning to not use it in a Production environment. Thus my concern is if it would go away. We have numerous customers that can benefit from this technology but need some assurance it will be a long lasting feature. Thanks.

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Shirley Wang responded

    We are working hard on a plan to move Data Sync forward. Thank you for your suggestion.

  8. Provide a progress bar for a given Sync Group rather than just displaying "Synchronizing..."

    Some type of progress bar indicating where the synchronization stands for a given sync group would be very helpful. e.g., I have been looking at a synchronization in progress for the last hour and I have no idea if the sync is actually doing anything or if it's stalled and just displays "Synchronizing".

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. where is SQL Data Sync options in the new portal?

    Why is there no option to do SQL Data Sync in the Azure Portal? It makes it seem like one of the ideas that may not get out of preview !

    16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Support a scheduled synchronization

    Add support for synchronizations to occur at a specific, reoccurring, time. Optional would be a timeout to stop the synchronization if it passes a certain time or a period.

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Allow bulk insert when first populates data to target database

    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.

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  Shirley Wang responded

    Data Sync team is planning to improve initial synchronization performance by using bulk insert and other optimization techniques.

  12. trustServerCertificate

    Allow the connection parameter trustServerCertificate=true to be set. This would allow SSL connections to be used even if the certificate is not perfect. Better than being forced to using an non encrypted connection.

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow data-tier applications (dacpacs) to work with Data Sync

    Data-tier applications currently don't work well with Data Sync because Data Sync modify the schema of a database which is wiped away when the dacpac is deployed again.

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Shirley Wang responded

    I believe this is indicative of a need to boostrap a speedy initial sync experience – we need to scale the initial sync to support 10’s of GB or even to 150GB.

  14. Get Notification when Data Sync fails

    Need to be able to get a notification if the sync fails. I cannot be checking in portal to find failures.
    Not having this ability would be a show stopper for me.
    Is there some sort of query I can use to monitor failures?

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Set filter option before refresh schema

    Include the possibility to use a filter before refresh schema is clicked. This will solve the issue with using databases with more than 500 tables if you only need a couple.

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow filtering (where clause to defined) for synced data

    I want to pull data from a table, however I don't need all the data. I only need the data which meets certain criteria and can be easily filtered with a where clause in a sql query.
    Allow to filter on column values.

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Enable PaaS-to-PaaS Transactional Replication

    When can we expect to be able to replicate from PaaS to PaaS? Sync agent is the only way to do this right now, and as everyone knows this is not the ideal solution (still in preview? support will never assist with issues...). Otherwise, we're being asked to pay high costs for the PREMIUM tier just to get active/readable replication. Or, go with an IaaS solution. Really hoping something is in the works here...

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. _Tracking Tables

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

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Sync data from Views to Tables

    Allow the data source to be a view instead of a table. Allows me to transform the data a bit before it's put up into azure.

    (Actually wonder if this it would work if I set the sync up with tables then switch them for views).

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Operation not supported on version 12.0 SqlAzureDatabase

    Fix issue that appear when refreshing list of source (hub) tables and generates the following error message:

    Getting schema information for the database failed with the exception "Failed to retrieve data for this request.
    Inner exception: Operation not supported on version 12.0 SqlAzureDatabase.
    For more information, provide tracing ID ‘6e7db290-b5f9-4782-aab8-5f1a945740d4’ to customer support."

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Data Sync

Feedback and Knowledge Base