Stack Overflow
Stack Overflow

Questions tagged [azure-data-sync]

SQL Data Sync is a service offered by Windows Azure to synchronize SQL Server and Windows SQL Azure Database instances

SQL Data Sync (Preview) is a service hosted in Windows Azure that enables the synchronization of SQL Server and Windows SQL Azure Database instances. At least one of the instances must be a Windows SQL Azure database.

SQL Data Sync was previously known as Windows Azure Data Sync Service.

SQL Data Sync is in Preview, meaning for example that it has no official support (aside the one given by the Windows Azure SQL Database forum).

93 questions
0
votes
1 answer

Use Azure SQL Data Sync on a Georeplicated Database

I have Azure SQL Georeplication setup on a production database. This process has worked fine for some time. The georeplicated database is on another server in an Elastic Pool. I now want to keep an on-prem database in sync and am considering setting…
DanielG
  • 1,669
  • 1
  • 12
  • 26
0
votes
1 answer

Azure SQL: How to Merge Multiple Db's into a Single Managing Db, while Syncing Bidirectionally any future changes

I have multiple devices with assignments, where each generating similar in structure data offline. Also each device periodically gets online to sync with an Azure SQL database that is separate and only assign to it. The devices also received new…
jamamirre
  • 3
  • 2
0
votes
0 answers

Azure Data Sync Stop working btw two Azure SQL Databases (without showing error msg )

I use Azure Data Sync to synchronize 2 Azure SQL Databases for 2 Tables, the synchronization works always good for 6-7 days , but I think every time when I make a new Deployment in the release pipeline (in azure devops) without changing anything in…
Z.Maz
  • 1
0
votes
2 answers

Setting up Azure SQL data sync's sync group

I just tried setting up Azure SQL data sync's sync group using sample Azure SQL database. I am syncing dbo.BuildVersion table of the sample database. I get the following error on member database. Database provisioning failed with the exception…
Chirag Shah
  • 23
  • 5
0
votes
1 answer

Clean up metadata Azure SQL Sync Database

Trying to create Azure Data Sync Group but every time when I create it, it throw following error Failed to perform data sync operation: An error occurred while executing the command definition. See the inner exception for details. After days of…
Saad Abbasi
  • 37
  • 7
0
votes
1 answer

Azure SQL Data Sync - how to execute a sync group with a logic app

I have an Azure SQL Database I have Azure SQL Data Sync that syncs that data to an on prem sql database I want to call the sync group to execute instead of waiting for the sql data sync time to occur. Mainly because i dont want the sync to happen…
magiva
  • 45
  • 6
0
votes
1 answer

can we create datasync between two tables without indexes in azure data sync

can we sync two tables of two different databases in azure without indexes. As, we all know ,if two databases has to be in sync hub database and member data base should have same schema. But is there chance of avoiding indexes. please help me with…
Hariprasad
  • 1
  • 1
0
votes
0 answers

Azure DataSync failed due to Bulk Insert command

Data Sync is failed due to below.I'm trying to add newly created table to the sync group.That table is having 4 records only.I tried deleting the sync group and recreating the sync group again.Please check the inner Exception.My databases Hub and…
Veeramalla Sandeep
  • 37
  • 8
0
votes
1 answer

Mobile Offline Sync database on Xamarin form

Currently looking at the Enable Offline Sync for Xamarin Form : https://learn.microsoft.com/en-us/azure/app-service-mobile/app-service-mobile-xamarin-forms-get-started-offline-data. I am having the code running on mobile and the backend run and…
LittleFunny
  • 8,155
  • 15
  • 87
  • 198
0
votes
0 answers

DataSync issue from FrontEnd

We are using azure data sync to sync data from one database to another. We have created a new sync group for another environment. we don't have any issues from backend as sync is running fine but we are having below DataSync error from Frontend side…
Veeramalla Sandeep
  • 37
  • 8
0
votes
1 answer

Onpremise Databases to Azure SQL Databases and Sync continuously

My requirements are as below : Move 3 SAP local databases to 3 Azure SQL DB. Then Sync daily transactions or data to azure every night. If transactions of local DB are already exists in azure, update process will do on these transactions if not…
Triple K
  • 379
  • 1
  • 3
  • 14
0
votes
1 answer

Azure Data Sync how do I set the order the tables are applied?

Right now Azure Data Sync is applying changes to tables in alphabetical order, which is also the same order we added the tables to the schema. This is causing issues because a child table is loaded before the parent and it hits the 1000 error…
Scott Thompson
  • 11
  • 1
0
votes
1 answer

Is it possible to set Primary keys in the HUB database in Azure Data Sync?

One of my tables in the HUB has a primary key that is causing records to be dropped in all the member databases. This Primary Key dynamically changes based on record updates. I understand that Azure data sync uses these keys to track changes, but…
sy-huss
  • 183
  • 2
  • 14
0
votes
1 answer

Creating Sync Group timed out

I'm trying to create a database sync between my on-premises database and an Azure database. I tried to create a Sync Group but after 1 hour of "Creating Sync Group" it timed out and canceled the creation. I've used Azure data sync multiple times and…
Nick Riethoven
  • 1
  • 1
0
votes
1 answer

Do I copy a db or use data sync to create and manage a db for testing in Azure

If I want a daily copy/replication of my production database, I know I can copy, but what happens when the size grows to ~100 terabytes or more? It doesn't seem logical to copy a db of that size everyday just to use for testing/QA. Ideally I'd like…
chuckd
  • 13,460
  • 29
  • 152
  • 331
1 2 3
4
5 6 7