Skip to main content
145 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
64 views

I'm having trouble with nullable dates. At first my model included this field: public DateTime CompletedDateTime { get; set; } When I changed it to... public DateTime? CompletedDateTime { get; set; }...
iPaul's user avatar
  • 75
0 votes
1 answer
155 views

I'm trying to set up Azure SQL DataSync to go from Azure to a locally hosted SQL DB. I've set up the hub and member dbs no problem. When I try to get a list of tables to sync on the hub DB, I get ...
Rob Marsh's user avatar
  • 591
0 votes
1 answer
53 views

I want to build a solution that consists of these parts: API Offline enabled Avalonia Client Admin website I set up a test implementation of CommunityToolkit.Datasync.Server and inspected the ...
nitech's user avatar
  • 1,832
0 votes
1 answer
203 views

We have a database in Azure SQL Server that we want to replicate continually to an On-Prem 2019 SQL Server. We are using Azure Data Sync but it fails every once in a while and we can't find out how to ...
daniel yunker's user avatar
  • 1
0 votes
1 answer
91 views

I created one direction flow (from member to hub) in SQL Data Sync for Azure. Would it be possible to change it later to bi-directional? I cannot find Sync Direction in Azure UI, found [syncdirection] ...
Serg's user avatar
  • 95
0 votes
0 answers
476 views

I created a sync between 2 databases in Azure, then I removed(deleted) the sync in Azure, but I still see a few tables that are from the sync(image below). Additionally there might be some other ...
chuckd's user avatar
  • 14.8k
0 votes
1 answer
339 views

I have a similar requirement but the other way. I.e I have a table in an Azure SQL database, which we need to copy data from the Azure SQL database to an on-premise SQL Server database. The table ...
vikranth reddy's user avatar
  • 3
1 vote
1 answer
112 views

we want to replicate our Production SQL Server DB to a historical ("reporting") DB, AND purge oldest data from Production. (The Production DB will only have the latest data, and the ...
user736570's user avatar
  • 521
0 votes
1 answer
119 views

I am looking for how to use the 'Include' method to specify related data for the EntityTableData or DataSyncClientData objects in the Microsoft.Datasync library. I would like to achieve something ...
Sam's user avatar
  • 139
0 votes
1 answer
78 views

Rather than use the built in admin for Azure Sync, I'd like to create a separate user and logon for it. Is this at all possible? What permissions would the user need, if so? I tried adding a user to ...
BaconCatBug's user avatar
  • 195
0 votes
1 answer
77 views

Is it possible to synchronize temporal table data with the main table using Azure Data Sync? I couldn't locate a comprehensive official documentation on this.Can anyone please help ?
Akhilesh Jaiswal's user avatar
  • 237
1 vote
1 answer
285 views

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 ...
RyanO's user avatar
  • 51
0 votes
1 answer
1k views

I would like to create a single directional sync transaction between the DBs. For Example: Azure SQL Server 1 has DB1 Azure SQL Server 2 has DB2 I would like the changes from DB1 to be synced to DB2. ...
Tasnim Khan's user avatar
  • 233
0 votes
1 answer
586 views

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 ...
sanheialan's user avatar
  • 1
0 votes
1 answer
735 views

I tried to use Export option from SSMS which gives an error saying failed due to foreign key relationship. How to copy data between tables(more than 400+) of two different azure sql server with has ...
Python coder's user avatar
  • 1
0 votes
0 answers
238 views

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 ...
Tony Fox's user avatar
  • 1
0 votes
1 answer
1k views

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 ...
rani chukka's user avatar
  • 11
0 votes
1 answer
663 views

Our current web application uses Azure SQL Database. We need to create a scheduled process for importing/exporting data from a SQL database in Azure Virtual Machine to Azure SQl database. And also ...
user1887852's user avatar
  • 11
0 votes
1 answer
430 views

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 ...
Raul's user avatar
  • 17
0 votes
1 answer
357 views

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-...
DanielG's user avatar
  • 1,630
0 votes
1 answer
591 views

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 ...
jamamirre's user avatar
  • 3
1 vote
1 answer
2k views

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 ...
Niall's user avatar
  • 13
7 votes
2 answers
6k views

I need to move all the data of a production database to its staging version. These 2 databases are Azure SQL Databases from 2 different resource groups. I have read some guides on how to achieve this ...
ddfra's user avatar
  • 2,615
0 votes
1 answer
285 views

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 ...
Z.Maz's user avatar
  • 1
-1 votes
1 answer
139 views

I am setting up a simple data sync, only updated at the Hub database and I want to specify he destination owner for the tables included in this sync group. Ex: The table dbo.TableName at the Hub ...
Trond's user avatar
  • 1
0 votes
2 answers
633 views

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. ...
Chirag Shah's user avatar
  • 23
0 votes
1 answer
2k views

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 ...
Saad Abbasi's user avatar
  • 37
0 votes
1 answer
533 views

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. ...
magiva's user avatar
  • 55
3 votes
1 answer
481 views

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 ...
Adam John's user avatar
  • 31
3 votes
2 answers
2k views

I am trying to install SQL Data Sync Agent 2.0 but I got this install error I am running virtual machines with Hyper-V. I tried in a windows server 2016 and a windows 10. Up to date. I added the ...
Jonathan's user avatar
  • 55
0 votes
1 answer
289 views

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 ...
Hariprasad's user avatar
  • 1
2 votes
1 answer
831 views

I need to merge with 2 different tables from 2 different azure SQL databases where as these two azure sql database are from same azure sql server. also for performance imporvement purpose, what I ...
Priyanka Mane-Patil's user avatar
  • 529
3 votes
1 answer
7k views

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 '...
deathrace's user avatar
  • 1,135
0 votes
0 answers
821 views

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 ...
Veeramalla Sandeep's user avatar
  • 37
0 votes
1 answer
5k views

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 ...
LittleFunny's user avatar
  • 8,453
0 votes
0 answers
93 views

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 ...
Veeramalla Sandeep's user avatar
  • 37
1 vote
0 answers
443 views

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 ...
Pablo Boswell's user avatar
  • 837
1 vote
1 answer
494 views

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 (...
Rabbi's user avatar
  • 4,752
0 votes
1 answer
84 views

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, ...
Triple K's user avatar
  • 399
0 votes
4 answers
3k views

Error : Getting Schema Information for the database failed with the exception unable to process a schema with 2434 500 Database Sync Group error on Azure syncing local offline server. What's the ...
kayd yonis's user avatar
  • 21
2 votes
0 answers
2k views

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 ...
Lennart's user avatar
  • 402
0 votes
1 answer
207 views

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 ...
Scott Thompson's user avatar
  • 11
1 vote
1 answer
493 views

I have seen some Azure DataSync tables and procedures in my Database.I'm not sure from where which database they are loaded. Is there any way to check the data sync group from SSMS?
Veeramalla Sandeep's user avatar
  • 37
1 vote
1 answer
110 views

I have 2 web application that the databases are azure sql. 1st web is used to record all payment and internal business rule 2nd web is used to capture request payment from external vendor I'm ...
Daleman's user avatar
  • 884
0 votes
2 answers
1k views

I am working on a WPF C# window application project. The project has its own local SQL database and my Azure server also has a database with the same details. If I add an entry or edit an entry to ...
XtremeCold's user avatar
  • 27
0 votes
1 answer
119 views

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 ...
sy-huss's user avatar
  • 193
0 votes
1 answer
317 views

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 ...
Nick Riethoven's user avatar
  • 1
0 votes
1 answer
388 views

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 ...
chuckd's user avatar
  • 14.8k
1 vote
0 answers
1k views

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 ...
Ali Carson's user avatar
  • 11
0 votes
1 answer
87 views

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 ...
kintela's user avatar
  • 1,343

1
2 3