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
2
votes
1 answer

SQL Azure failover / backup strategy for web app

I'm building a web app using Azure & SQL Azure. I'm setting it up so each organization has their own database. Low to moderate traffic per customer organization. I'm thinking about using SQL Azure Data Sync as part of a failover/backup plan, so…
PeteShack
  • 707
  • 1
  • 8
  • 20
1
vote
1 answer

Data Sync SQL Server 2008 R2 to Azure Error

I am trying to data sync my SQL Server 2008 R2 to Azure database but I am getting an error: Microsoft.Synchronization.Data.DbSyncException was unhandled Message=Failed to execute the command 'BulkInsertCommand' for table 'SleepBrightness'; the…
tnanoha
  • 55
  • 1
  • 7
1
vote
1 answer

How to reuse lambda expression on entities with different property names in EF Core with MS Data Sync?

In ASP.Net EF Core I have various entity models with corresponding controllers which inherit from Microsoft.AspNetCore.DataSync.TableController and each model inherits EntityTableData from the same DataSync library so as to facilitate the Offline…
RyanO
  • 21
  • 4
1
vote
1 answer

Removing data sync meta data from Azure Sql database copy

I'm trying to export our production Azure SQL database to local for testing purposes. I've made a copy of the database but get the following error when trying to Export. One or more unsupported elements were found in the schema used as part of a…
Niall
  • 13
  • 3
1
vote
0 answers

Easiest way to script drop and create Azure SQL Data Sync group

My sync group is out-of-date and currently not syncing correctly to the member database. First, I would like to script out the existing definition if possible. If not possible, then I want to create a PowerShell script to allow me to drop and…
Pablo Boswell
  • 805
  • 3
  • 13
  • 30
1
vote
1 answer

Use Azure data sync with localdb

B"H How can I use Azure Data Sync with localdb? Please note: I am not asking about using it with a "Local Database" as in an on-prem database. I am speaking specifically about the technology (particular Sql Server Edition) known as localdb. As in…
Rabbi
  • 4,622
  • 9
  • 35
  • 45
1
vote
0 answers

How do I connect to a database which I am viewing in Azure data studio, in R studio?

I am trying to access a database which I am viewing in Microsoft Azure Data Studio, in R studio. I do not come from a programming background so I am a little confused. I am also completing this from a Mac Computer. I am most confused about the…
Ali Carson
  • 11
  • 1
1
vote
1 answer

Azure SQL Data-Sync. Issue with Syncing more than 30 Onpremesis Databases to single server

I have run into an issue when trying to sync more than 30 on premises DBs on a single Azure SQL Database. It is giving me the following error. Whats the best workaround for this error. We need to setup more than 30 SQL Databases…
Waqar
  • 216
  • 1
  • 8
1
vote
1 answer

Move Azure SQLDB using SQL Data Sync to new resource group

The Googles are failing for my specific concern. Has anyone moved a database (DBaaS) and the associated parent resource which is part of a SQL Data Sync Group to a new resource group within Azure? I've found that moving the database is supposed to…
IsThisThingOn
  • 21
  • 7
1
vote
0 answers

Azure Data Sync Rest API

Is there a REST API that I can use instead of this application? I currently using the Data_Sync_Preview_REST_API.pdf but I think it doesn't have the capability to add your local server to Azure. I need the functionality with the arrows below for…
jmaghuyop
  • 115
  • 1
  • 9
1
vote
0 answers

How do I use multiple triggers in an Azure Logic app?

I'd like to sync fresdesk tickets on create or update - do I have to create 2 seperate logic apps, one for create and one for update, or can I somehow create an "or" trigger in the logic app for either create or update events - then flow that into…
MonkeyBonkey
  • 46,433
  • 78
  • 254
  • 460
1
vote
1 answer

SSIS Data Transfer from Azure SQL to On-premises SQL Server 2016

Is there any way to transfer the large volume of data from Azure SQL to on-premises SQL Server 2016 Enterprise/Standard? The requirements prescribed as follows: Weekly full database transfer Daily delta transfer before midnight I read about SSIS…
Thurein
  • 2,536
  • 7
  • 34
  • 49
1
vote
2 answers

Azure Data factory vs Data sync

Our assignment is to copy & transform data from on-premises SQL Server into Azure SQL database once in a day. We have made some tech trials and both Azure Data Factory and Data Sync are technically possible approaches for our problem. So, what are…
Tikke
  • 131
  • 2
  • 8
1
vote
1 answer

InHouse authorization on Azure Easy Tables

We are using the sync feature of the Azure Easy tables from our iOS App. We have implemented our own Authentication and Authorization in our system. I have done it for Easy APIs. I want to extend the same logic on Easy Tables sync also. I am not…
Mokhamatham Sri Hema Kiran
  • 31
  • 3
1
vote
1 answer

Azure Mobile Services with Existing Database (without Schema changes)

As a disclaimer I warn that there may be malformed understandings going on here, hopefully not, but maybe. The Situation: There is an existing Windows VB Timesheet Application that deploys on customers Windows devices (not RT). This application…
invke
  • 21
  • 5
1
2
3 4 5 6 7