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. Off line Sync feature

    Feature to sync between two database, once they are connected to net or by moving some files to other machine and sync with othere database

    25 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
      under review  ·  Shirley Wang responded

      This is an interesting idea – allowing source to turn on change tracking, but not requiring the sync group to be persisted but rather the sync relationship established dynamically.

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

      24 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  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.

        22 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          4 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • Support for different on-premises databases

          On-premises SQL Server databases can currently be included in a Sync Group. Would you like support for other databases; if so, which ones?

          21 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            6 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Provide more meaningful error message

            To be helpful on problem investigation.

            20 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
            • 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
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                under review  ·  Shirley Wang responded

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

              • Provide a progress bar for a given Sync Group rather than just displaying "Synchronizing..."

                Some type of progress bar indicating where the synchronization stands for a given sync group would be very helpful. e.g., I have been looking at a synchronization in progress for the last hour and I have no idea if the sync is actually doing anything or if it's stalled and just displays "Synchronizing".

                17 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  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 !

                  16 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    2 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.

                    15 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Support a scheduled synchronization

                      Add support for synchronizations to occur at a specific, reoccurring, time. Optional would be a timeout to stop the synchronization if it passes a certain time or a period.

                      14 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow bulk insert when first populates data to target database

                        It took over 10 hours to move 6GB of data to target database on the first synchronization. When I used SQLAzureMW, it took less than hour.

                        14 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          planned  ·  Shirley Wang responded

                          Data Sync team is planning to improve initial synchronization performance by using bulk insert and other optimization techniques.

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

                                10 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • _Tracking Tables

                                  No need to create a _Tracking table in case the Database is read only. This will improve the performance of Data Sync.

                                  9 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Allow data-tier applications (dacpacs) to work with Data Sync

                                    Data-tier applications currently don't work well with Data Sync because Data Sync modify the schema of a database which is wiped away when the dacpac is deployed again.

                                    9 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                      under review  ·  Shirley Wang responded

                                      I believe this is indicative of a need to boostrap a speedy initial sync experience – we need to scale the initial sync to support 10’s of GB or even to 150GB.

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

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