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
1
vote
2 answers

Azure SQL Database SYNC column does not allow nulls warning

I have a Microsoft SQL Data Sync Agent job set up to sync our local server to Azure. It was working great, then we made a few updates locally and it didn't remove the deleted rows from Azure, and now the sync fails with a warning: Sync completed…
AndyD273
  • 7,177
  • 12
  • 54
  • 92
1
vote
1 answer

SQL Azure Data Sync vs Standard Geo Replication

What is the difference between Data Sync and Standard Geo Replication on SQL Azure databases? I understand that Active Geo Replication provides the ability to connect to a replicated database whereas Standard does not allow connections. However,…
joeldow
  • 1,048
  • 1
  • 9
  • 19
1
vote
1 answer

Unsupported Data Type when using SQL Data Sync to Azure

I'd like to sync an on-premise SQL Server 2012 SP2 database to Azure using SQL Data Sync. When I try to do the sync I get "Unsupported Data Type" error on one of the tables for the ID_Index column: The Azure Management Portal gives no further…
Bedford
  • 1,136
  • 2
  • 12
  • 36
1
vote
0 answers

sql azure data sync - transactions

Trying to use SQL Azure data sync for a unidirectional sync between two SQL Azure databases. Most of the transactions that hit the master database are either read committed or serializable. I am assuming the SQL Azure data sync synchronizes data…
user529265
  • 820
  • 10
  • 27
1
vote
1 answer

Azure Data Sync + EF Automatic Migrations

How does Azure Data Sync handle EF Automatic Migrations? Is there a way to specify a precondition of matching migration levels before allowing synchronization? This question is related, but only asks how EF Automatic Migrations handles consistency…
Lilith River
  • 16,204
  • 2
  • 44
  • 76
1
vote
1 answer

SQL Data Sync portal doesn't see any tables or schemas

I was trying out the new Data Sync from the new portal. But when I try to add the sync rules (which I think it's required to start syncing) doesn't load the schemas and tables. I created the tables in both databases, just for testing, but nothing…
MaltMaster
  • 758
  • 1
  • 10
  • 25
1
vote
4 answers

Which ways do I have to import my tables and data from SQL Server to SQL Azure?

I'm looking for the easiest way to import data from SQL Server to SQL Azure. I'd like to work locally, would there be a way to synchronize my local database to SQL Azure all the time? The thing is I wouldn't like to update each time I add a table in…
Darf Zon
  • 6,268
  • 20
  • 90
  • 149
1
vote
1 answer

Foreign Key Reference Error for Azure Data Sync

In My Data Sync Group there have 2 tables . Let say A and B . some columns of A reference to B table. B is Master Table. When sync occur table A is do the processing ahead of Table B. So I got the Foreign Key Reference Error. IS Azure Data sync…
CKyaw
  • 63
  • 1
  • 9
1
vote
1 answer

Get Schema error when making Data sync in Azure

I finished setup for the making Azure hub and installing Client Agent and Database . Then define dataset. That time whatever database i chose and click get latest schema, got the error. Error is The get schema request is either taking a long time…
CKyaw
  • 63
  • 1
  • 9
1
vote
1 answer

SQL Azure Data Sync not possible when a trigger is set

I try to use SQL Azure Data Sync to sync between SQL-Azure-DB and on-premise SQL-Server 2008R2. I have to sync only one table with now only 90 rows. The table on the Azure-side has a trigger set, but the table on my local sql-server doesn't have…
Géza
  • 2,492
  • 1
  • 17
  • 12
0
votes
1 answer

Any way to synchronize all premise databases in one go through 'Sql Azure Sync Group'?

I have two on premise databases in my synchronization group in sql azure. When I synchronize the group manually, I see that only one of the premise database gets all the updated data and the other one does not. I have to synchronize a second time…
teenup
  • 7,459
  • 13
  • 63
  • 122
0
votes
1 answer

Azure SQL Data Sync No Response

I started to run Azure SQL Data Sync to an empty DB, from Azure SQL Database to another Azure SQL Database in the same Azure SQL Server, however, it found that the Sync State no response for more than 2 days, there is no any new data insert or…
sanheialan
  • 1
0
votes
0 answers

Microsoft.Datasync.Client SSL error with Xamarin Forms

I'm developing a Xamarin Forms app with an ASP.NET Core WebAPI which use the Microsoft.Datasync.Client & Microsoft.AspNetCore.Datasync libraries to do offline syncronisation. Unfortunately, I'm getting an error when the ToListAsync() method is…
Tony Fox
  • 1
  • 1
0
votes
1 answer

Azure data sync is in processing state, how do I know how long it will take to complete?

I am processing around 12GB of data from hub to destination, and both databases are Azure SQL Databases. I see a lag of more than 18hrs. And Sync is in processing state for more than 14 hrs. How do I know how long it will take to complete?. Current…
rani chukka
  • 11
  • 2
0
votes
1 answer

Azure SQL DataSync ##MS_SyncAccount## missing

The automatic sync from my syncgroups stopped in SQL Azure DB. Running the health check script provided by Azure one of the warnings mentioned that ##MS_SyncAccount## is missing. I tried to create it as below... CREATE USER…
Raul
  • 17
  • 4
1 2
3
4 5 6 7