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

AZURE DataSync troubles

After refresh Schema of Hub dataBase I can not select tables to synchronize because the list of tables found does not show any check box next to can select them Any error but any checkbox Any idea please?
kintela
  • 1,283
  • 1
  • 14
  • 32
0
votes
2 answers

API for On-Demand trigger for the Azure Data Sync

Is there anyway we can trigger the Azure Data Sync on-demand via API without using the automatically sync?
user3227412
  • 187
  • 1
  • 2
  • 16
0
votes
1 answer

How to use both Auto and Manual sync option with Bi-direction Azure sync data?

My company currently set up the database on the Azure cloud. I've also set the Data Sync feature, which will allow us having the local database backup with every 5m sync automatically, it's a From the hub sync direction. Now we want to set up the…
Loc Nguyen
  • 61
  • 1
  • 9
0
votes
1 answer

Data sync between on Prem MySQL and Azure Data Store

We have a legacy system which talks to on-premise MySQL database. We are building a new system and its hosted in Azure. The database it uses to store the data is in Azure Storage. Since the legacy application will be functional for some time, we…
Manu
  • 331
  • 3
  • 15
0
votes
2 answers

SQL Data Sync Feature - Trouble refreshing Schema between 2 SQL Azure DB's (Hub & Member DB)

Agenda: We want to achieve a scenario where we should be able to sync all of the data pushed in our production SQL azure DB to Test SQL Azure DB [ Hosted under the same SQL server ] via "Sync To other Database" feature in SQL Azure. Error: "Database…
Girish Kalamati
  • 11
  • 3
0
votes
1 answer

Filtered one-way synchronization of Azure SQL database

We have a multi-tenant, single db application where some customers have expressed the desire to get direct access to their own data. I have been suggested looking into Azure Data Sync to achieve a setup where each of the customers get their own…
Christian A. Rasmussen
  • 250
  • 3
  • 17
0
votes
0 answers

Do changes to datatypes on an established data-sync throw errors?

Our MI reporting solution involves pulling data on-prem into a DMZ from an Azure SQL server, via Azure Data-Sync, then performing ETL processes on it etc. The Azure SQL server is maintained by a third party who keeps adding columns to existing…
Yemp
  • 1
  • 1
0
votes
1 answer

Azure Offline Sync Updated At pulls whole data during the Incremental Sync

I have a table controller, which has one way sync (Only get since there is no any update from mobile). So the very first time when I do the PullAsync it has pulled whole data since my Update At filed has the same timestamp for all the records. Now…
Thabo
  • 1,492
  • 2
  • 18
  • 36
0
votes
1 answer

How to regularly download Geo-Replicated Azure Database (PaaS) data to On-Premise database

We have a geo-replicated database in Azure SQL (Platform as a Service). This is a master/slave type arrangement, so the geo-replicated database is read-only. We want to download data regularly from this Azure SQL database to a SQL Server database…
Stefan Zvonar
  • 3,959
  • 3
  • 24
  • 30
0
votes
0 answers

Azure Offline DataSync - Insert multiple records on single request

I am using Azure offline data sync framework to sync mobile app data to server. But I am seeing huge performance hit. Time taken to sync 2000 records of data is around 25 min. When I had further analysis, each http request is taking around 800ms…
Chandu
  • 1
  • 1
0
votes
1 answer

Using Azure Data Sync between databases at different Azure datacenters

We are looking to host our Azure web application at 2-3 locations globally to reduce load latency and for BCP if an application server fails (we will use Traffic Manager to direct traffic) We will be co-locating the Azure SQL DB databases along with…
user7995357
  • 151
  • 10
0
votes
1 answer

Azure SQL Data Sync: Can you set up a sync that does not replicate deletes?

I want to have 2 Azure Databases. One will act as an exact replica of an offsite database. That database will regularly purge data that becomes stale. I would like to have a second database (i.e. Archive Database) which replicates the all Inserts…
Joseph U.
  • 4,457
  • 10
  • 41
  • 47
0
votes
1 answer

How to know whether an update was successful while updating using azure offline sync?

In the android client app if we update a row in local DB by using azure mobile sync services as follows, then how can we know whether the update was successful ? mToDoTable.update(workflows).get();
Akhil MG
  • 54
  • 7
0
votes
1 answer

Azure SQL Server Sync Data between different Accounts

We have two separate Azure Accounts. We wish to one way sync SQL database table data every x minutes between the two. Account 1 => Sql Database => Table Account 2 => Sql database => Table SQL Server Sync group can not be used as these are two…
user3395924
  • 125
  • 1
  • 7
0
votes
1 answer

Getting a server error (500) as soon as File Sync is used in Xamarin Forms app

Sample Source Code: https://drive.google.com/file/d/0BzYXG8uD6JT3ai1SN3lfRE5oNWs/view Background: Creating a Xamarin Forms app with Azure Data Sync with Azure app Services as backend. Using Dot Net based Managed backend on azure. My Issue: My app…
Supreet
  • 831
  • 1
  • 9
  • 30
1 2 3 4
5
6 7