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.

How can we improve SQL Data Sync?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. 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…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Prevent resetting REGION after selecting subscription when creating a new Sync Group

    In Japanese language portal,
    when I try to create a new Sync Group,
    I enter NAME, select REGION 'east asia' and then select one subscription from our multiple subscriptions.

    However after selecting one subscription,
    it causes the region reset to US north.

    I hope the region remains my selection.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Change the subscriptions of DataSync

    Presently there is option to change the subscription of azure SQL server but there is no such option to change\move the DataSync to other subscription.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow backup of databases that contain sync groups

    Currently the only way to backup a database that contains sync groups is to either deprovision the sync groups, or make a copy of the database, deprovision the sync groups in the copy, and backup the copy. This adds unnecessary time and inconvenience to backup process for any database that contains sync groups.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
1 2 4 Next →
  • Don't see your idea?

SQL Data Sync

Feedback and Knowledge Base