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
6
votes
0 answers

Azure Data Sync Error - The INSERT statement conflicted with the FOREIGN KEY constraint

I'm using Azure Data Sync to synchronise two databases which also contain ASP.NET Identity Tables. Everything was working fine until a few days ago when I inserted around 1500 users in the Hub Database. Since then I'm getting the following…
Florin D. Preda
  • 1,358
  • 1
  • 11
  • 25
3
votes
0 answers

Azure Data Sync To Tables with Different Name and Schemas

I'm trying to create a SYNC on Azure. I have 3 different databases on prod. I want to move some tables of those DBs to reporting environment with different schema and different table names. Let's assume I have 3 Dbs names A, B , C. I will move…
ibrahimozgon
  • 1,137
  • 1
  • 12
  • 19
3
votes
1 answer

Row filtering in SQL Azure Data Sync - is it gone?

I'm going to use SQL Azure Data Sync service to synchronize an SQL Azure and an on-premise database (one-way, from Azure to the on-premise db). But I need to filter rows to synchronize (based on column value). E.g., this tutorial tells how to…
nativehr
  • 1,131
  • 6
  • 16
3
votes
1 answer

Sql Data Sync fails and no logs are available

I have 2 SQL data sync groups setup First one does a 1 way sync from azure to local db. Sync's only 1 table. Second one does a 1 way sync from local db to the azure. Syncs 2 tables. After setting it up and getting a few sync errors I was able to…
ambidexterous
  • 832
  • 12
  • 21
3
votes
1 answer

Want to maintain Single SQL Azure DB across multiple regions

In my application I have scenario like below. User downloads our application exe and includes in their application hosted in azure We have one REST API in every region for receiving data from application so that data transfer will not cost to the…
Ruchit Rami
  • 2,273
  • 4
  • 28
  • 53
2
votes
1 answer

Azure Data Sync Error - Member Database is Read Only

I have configured Azure Data Sync between our SQL on-prem and Azure SQL. Sync direction is to Hub (Azure) and conflict resolution is set to Member Win. Sync group has been configured successfully, and I have selected the tables I want to sync in the…
Adam John
  • 21
  • 3
2
votes
1 answer

How to set value of -DefaultProfile (of type IAzureContextContainer) in New-AzSqlSyncMember

I am trying to create a powershell script to create azure data sync between 2 azure SQL databases. My member database is on another subscription. I need to set -DefaultProfile which is of type on 'New-AzSqlSyncMember' command. I am not aware of the…
deathrace
  • 908
  • 4
  • 22
  • 48
2
votes
0 answers

Azure SQL data sync initial sync not working

I need to setup a constant sync between two databases on Azure on the same SQL Server. The database is about 2TB with 2000 tables and about 20 million rows. I cannot setup an Azure data sync because each time, it freezes on "refresh schema" in the…
Lennart
  • 383
  • 4
  • 16
2
votes
1 answer

How to monitor the Azure data sync process in Azure Portal

I am using Azure Data Sync to load data from one database to another. I want to monitor the performance and the resource consumption of the data sync between the two databases. I know that Azure portal has some monitoring tools but how can I use it…
Sindu_
  • 1,347
  • 8
  • 27
  • 67
2
votes
1 answer

Approach for using Azure VM for SQL

Following is the exact scenario in my application: SQL Server database is hosted on-premise locally in US office for development purpose. Developers are distributed in 3 different regions (US, India and Australia). Developers from India and …
Nirman
  • 6,715
  • 19
  • 72
  • 139
2
votes
0 answers

Azure data sync troubleshooting upload failures

In the Azure data sync logs every sync I get a warning message that claims that 4 upload records have failed. However there is no detail associated with the log record, so I have no idea what table these 4 records are missing from or what the PK is…
Aheho
  • 12,622
  • 13
  • 54
  • 83
2
votes
1 answer

Azure DataSync with SQL Azure databases across subscriptions

I am trying to synchronise databases in two different subscriptions using Azure datasync on the new portal https://learn.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync On the portal, I do not get the ability to choose…
user7995357
  • 151
  • 10
2
votes
0 answers

SQL Server Change Tracking on an Azure replicated DB

I have a requirement of a syncing set of tables (with data) to a different database from our production database. This is an Azure SQL DB. I created replicated DB (using Azure Geo Replication) and it is a read-only DB. My plan was to enable SQL…
Thilok Gunawardena
  • 924
  • 5
  • 22
  • 44
2
votes
1 answer

Sql Azure Data Sync Agent invalid key error message

Windows 8 64 bit DAta sync agente ver. 4.0.89.0 Error message , I tried reinstall 3 times data sync and 4 tiems new agent and new key also. No prosy or internet fire wall one no other fire wall software also. Please enter a valid agent key to…
user2390911
  • 21
  • 2
2
votes
4 answers

Entire local database sync with sql azure

I am developing a windows application which is using local database. I want to add a function to sync all local data to the sql azure. Currently I used following code. It enabled me to sync one particular table successfully., here is "Author_Master"…
las
  • 67
  • 1
  • 3
  • 13
1
2 3 4 5 6 7