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. Where can one find SQL Data Sync options in the new portal?

    Windows Azure is announcing that SQL Database will no longer be available on the new portal. What will happen to Sync Preview feature. We use it to deliver a very useful business system for our clients. Hope we can see this option in the new portal to help us deliver more

    15 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • 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.

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
      • 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
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • 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...

          6 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • 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 !

            14 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              2 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • 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

              4 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
              • 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.

                21 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • 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).

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

                    Interesting trial! Sync data from views will be quite complex and not always achievable. Could you comment on what kinds of transformation you need against the base table before syncing, and why you cannot sync the base table then do the transformation in cloud? – Linda Wang

                  • 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.

                    5 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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.

                      13 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                      • 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?

                        67 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          10 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

                        • 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.

                          17 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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.

                              36 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • 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
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  under review  ·  Shirley WangShirley 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!

                                • 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 "

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                    under review  ·  Shirley WangShirley Wang responded

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

                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      under review  ·  Shirley WangShirley Wang responded

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

                                    • 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
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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.

                                        3 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          under review  ·  Shirley WangShirley Wang responded

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

                                        • 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
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          SQL Data Sync

                                          Feedback and Knowledge Base