Questions tagged [sql-data-sync]

SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple SQL databases and SQL Server instances.

Filter by
Sorted by
Tagged with
0 votes
1 answer
205 views

Azure SQL Database Sync Login Issue

I wish to transfer data between two different databases on the same Azure SQL server (not managed instance). I have an admin account. When i goto setup Data Sync within the Azure portal i cannot see ...
AutomeShane's user avatar
0 votes
2 answers
151 views

Sql server database synchronization on 2 different server

I need advice on setting up synchronization between 2 SQL Server 2016 databases on standalone servers in different sites. What techniques should I best use and how should I go about setting up ...
SHMDBA's user avatar
  • 31
0 votes
1 answer
82 views

Azure Data Sync Between Two Azure Databases

I would like to ask if I use Azure data sync with my two azure databases is there any way that I can still download data tier and install it on my local machine. I am planning to create a sync between ...
Nathan's user avatar
  • 29
-1 votes
1 answer
734 views

How to sync data between two databases on two different ms sql server instances - one 2008 and the other 2016

What is the easiest way to sync data between two databases on two different instances. I am not thinking replication. Just sync e.g. production database to test database from time to time.
myusu's user avatar
  • 1
0 votes
1 answer
809 views

Change Data Capture in MySQL/PHP by writing to a MySQL table (rather than streaming to Kafka/Rabbit/etc)?

I have a small internal web app I'm developing with PHP and MySQL. I'm looking to sync client webpages to a server by requesting all changes since a certain date. I've found a number of solutions ...
dallin's user avatar
  • 103
0 votes
3 answers
2k views

Sync between two database on azure

I would like to ask a question how to setup azure syncing of two database on azure i need real time data replication to the other database
Nathan's user avatar
  • 29
0 votes
1 answer
2k views

Load data from a temporal table to another temporal table in Azure

Currently we have only a Live Database where all our data resides. I have created a separate Azure server and DB for development. The DEV DB should be some what up to date with the Live DB for ...
Sindu_'s user avatar
  • 103
0 votes
1 answer
42 views

Tools to ingest data to database in periods [closed]

We have an application that can work with Oracle or MySql or SQLServer databases. Also, there is a 3rd party data source that we need to have it's latest data records in our database every 15 minutes. ...
S.Yavari's user avatar
  • 103
1 vote
1 answer
284 views

Problems of having DR as Synchronous Commit

In our always on set up we have One Primary and One Secondary as Synchronous Commit and the DR as asynchronous commit. If i want to change the DR to Synchronous Commit will there be any performance ...
SQL_NoExpert's user avatar
  • 1,049
2 votes
1 answer
1k views

Does Azure SQL Data Sync support MySQL or SQLExpress?

I did see that it supports SQL Server (2005 and later) but does it support syncing between a SQLExpress server or MySQL server and an Azure Server? I'm trying to use it with a SQLExpress server but ...
Goalaso's user avatar
  • 33
1 vote
2 answers
6k views

Transaction replication from SQL Azure database to on-premise SQL server

I have a use case where I need to keep an on-premise SQL Server database in-sync with my Azure SQL database. Is there a way I can set up replication / sync from the Azure SQL db to the on-prem db?
xdev's user avatar
  • 111