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. More Status Info please please please!

    Dispay the names of tables that are currently synched, their status, and how many rows are synched for each table.

    3 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. Support circular dependencies!!!

    Circular dependencies need to be supported and it's been voted on over 300 times, please add this feature!

    3 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 →
  3. Support sync to occassionally disconnected SqlServer express subscribers

    Support sync to occassionally disconnected SqlServer express, with >30 (eg 150) subscribers, or 30 dynamic but concurrent subscribers

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Provide some sort of warning in the Azure Portal regarding the schema modification that occurs during SQL Data Sync

    I would like more transparency in to what occurs during the SQL Data Sync when creating it in the Azure portal.

    I created a Sync group, tried running it, the sync failed, and left the Hub database throwing SQL errors in my web app. Thus, there should be some sort of notification that the Hub database is modified when running the Sync.

    2 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 →
  5. Are there any way to use SQL Data Sync with "Allow access to Azure Service" OFF

    As far as I know, as of now we have to enable "Allow access to Azure Service" ON when we use SQL Data Sync. However, I don't want to enable this option because any applications in Azure can pass through firewall rule and this may be security vulnerability.

    I'd appreciate it if you could provide public IP address on Azure Data Sync Agent to be restricted on Azure SQL Server's firewall rules.

    6 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 →
  6. Sync table between Row-stored and Column-stored

    I want to use the Row-stored table for OLTP,
    and to use the Column-stored table for Analyze using Power BI.

    So, I hope to sync table between Row-stored and Column-stored.
    There are the Row-stored table on Azure SQL Database standard,
    and There are the Column-stored table on SQL Server Express.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Fast one-way sync

    Have any easy to configure one-way, all tables sync.

    5 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 →
  8. 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.

    14 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 →
  9. Support user-defined data types

    Much of my database is user-defined types, which aren't supported.

    6 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 →
  10. Allow multiple logins to same server/database

    Allow adding same server and same database with different logins. Currently if I try to add another connection to the same database on the same server, the action is aborted.

    5 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 →
  11. Have EventHub as a target for data sync

    If Data Sync could send data to event hub reliably from SQLDB or SQL on premise one could then build your own processing, whether it be to DW, DB, stream insight, aggregate etc.

    5 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 →
  12. Sync on specific date

    I need the ability to sync two databases on a specific date e.g midnight on 5th of each month. Currently the frequency can only be set monthly.

    6 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. SYNC Preview - sync rules not loading

    Hello,

    I'm using SYNC Preview to sync 2 SQL db servers located in different countries. I have a bug to report - the tab "Sync Rules" is not loading when clicked. I have experienced this issue since 10-24-2015 and am not able to successfully SYNC due to this bug. I may have to use a different cloud service to host our company's SQL databases if this bug persists as this bug makes it impossible for me to successfully sync our databases. Any info. regarding workarounds or solutions would be appreciated.

    Thank you,
    Andrew Tomp

    5 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 →
  14. Provide a roadmap for SQL Data Sync

    Provide information on what Microsoft has in store for the future of Data Sync. There has been hardly any work or updates to it in years, it has been in preview for that whole time.
    I really want to use this service as there is no equivalent on the market, but am hesitant to as it could be discontinued at any time.

    Is this product dead?

    81 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion! We are actively working on the roadmap, and will share publically when we have a concrete plan. Meanwhile, it would be great if you could share with us what scenario are you looking to use sync for. If you would like to be contacted offline, do leave a message and I’ll get back to you. — Linda Wang

  15. 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).

    10 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 →
  16. 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 →
  17. Allow continuous synchronisation or intervals less than 5 minutes

    Current smallest interval is 5 minutes, allow me to set this to between 1 and 4 minutes or a continuous synchronisation option. A wait of up to 5 minutes for sync is not always acceptable.

    110 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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 →
  19. The UI status should be more accurate of what is processing or in progress.

    The message should be more accurate like "Processing - Sync Provisioning", "Processing - Sync of Group ID 'dsafksdfjds' in progress "

    8 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

    Great feedback! Agree that the progress message can be more accurate! Thank you for your suggestion.

  20. Export-Import Sync Groups

    Have an option to script out sync groups. Or import-export sync rules, this will help save some time to set up same sync rules for multiple environments, rather than setting up sync rule for each table.

    6 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

    Thank you for your suggestion! We will consider this request as we priority our feature backlog.

← Previous 1 3 4
  • Don't see your idea?

SQL Data Sync

Categories

Feedback and Knowledge Base