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. ability to rename schema and table names

    if we need to sync 10 databases to single database and have some common tablenames, we can't use data sync. Can It provide an option to rename schema as well as table in destination so that we have same data from different databases without worrying for the names.

    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 →
  2. 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.

  3. 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 →
  4. Shorten the time for loading Log page

    Currently the Azure Sync Log inside the Portal take too much time to load if my sync group was created long time ago. i.e. for those new sync group with only a few logs, it will take around 5 seconds for loading. However, I've many sync group created more than 1 year, and it will take me up to 10 minutes for viewing the first page of the logs.

    It seems the Portal will download ALL the logs to my browser even I just want to view the most recent logs (maybe I just want to view the last 10…

    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

    You are absolutely right! The log page currently loads all log messages and there isn’t a way to filter by time range. We will add this to our backlog. Thank you for your suggestion!

  5. Add a "Validate" or "Repair" function in the Sync Agent

    Currently if the "instead of" triggers are (for whatever reason) removed from a table, changes are no longer tracked. In this scenario no logs are raised anywhere and the sync continues to show a healthy state, even though changes are no longer being sync'd from the client back to the Hub.
    When a DBA or application modifies the schema of the table it is possible that the result might be a table with similar structure but now without the triggers.
    We need a quick way to check for these kind of discrepancies and fix them when detected.

    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. Support filtered indexes

    We used a member database that included a table with a filtered index (i.e. WHERE is_deleted = 0).

    The initial sync recreated the table and the indexes, but omitted the where condition, which made subsequent syncs fail.

    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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 "

    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 →
    under review  ·  Shirley Wang responded

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

  13. 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 →
  14. Improve Log Readability on Error

    If a sync agent or sync group fails, the error is long an very difficult to read in the blade. You should be able to click on the error and it expand to another balde

    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 →
  15. Include a view to display number of source changes(inserted ,updated and deleted)which help user to run on demand Sync

    Include a view to display number of changes(inserted ,updated and deleted) occurred in source which help us to run on demand Sync

    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 →
  16. 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 →
  17. Hi, we need to have access to the sync pipeline to be able to change some values depending on the destination databases as well as improve c

    Hi,
    We need to have access to the sync pipeline to be able to change some values depending on the destination databases as well as improve conflict resolution.
    Thanks for your help

    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 →
  18. Option to enter proxy address and credentials in the application

    For enterprise customers, add a field for the proxy address and credentials ti use when connecting to internet.

    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 →
  19. Allow IaaS to PaaS

    Allow Data to Sync from a VM running SQL to an Azure SQL PaaS model, provided the Database passes the compatibility test.

    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 →
  20. Make it possible for VS Schema Compare to ignore tables, triggers, etc added by data sync

    We use Schema Compare to detect/make changes to our databases. Data Sync adds a bunch of Tables, Procedures, Triggers, etc. and it makes it hard to use the schema compare tool. Just unchecking all the checkboxes so Schema Compare knows to ignore the Data Sync stuff is a pain and then we still have to wade through a ton of items every time we do a schema compare.

    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 →
  • Don't see your idea?

SQL Data Sync

Feedback and Knowledge Base