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. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. Allow date / datetime as part of the primary key

    I have a few tables that use date and datetime as part of the primary key, and would like to be able to synchronise these tables which is currently unsupported.

    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 →
  11. 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 →
  12. 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 →
  13. 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 →
  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. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  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 →
← Previous 1 3 4
  • Don't see your idea?

SQL Data Sync

Categories

Feedback and Knowledge Base