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
0answers
14 views

SQL Server Bi-direction replication with different schemas

I have a requirement when upgrade legacy system, the legacy database schema is quite different from the new database schema, we need to change user back and forth to use the system since the new one ...
0
votes
2answers
64 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 ...
0
votes
1answer
20 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 ...
-1
votes
1answer
152 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.
0
votes
1answer
195 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 ...
0
votes
3answers
1k 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
0
votes
1answer
209 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 ...
0
votes
1answer
29 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. ...
1
vote
1answer
164 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 ...
2
votes
1answer
645 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 ...
1
vote
1answer
3k 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?