Questions tagged [data-synchronization]
The data-synchronization tag has no summary.
202 questions
0
votes
0
answers
9
views
Data duplication after Apache IoTDB pipe restart, how to maintain the existing sync progress?
When using Apache IoTDB's pipe feature to sync data to another Apache IoTDB instance, I encountered duplicate data transmission. The scenario is as follows:
I configured a Pipe from root.source to a ...
- 101
0
votes
0
answers
31
views
Periodic copying, synchronizing, forwarding and merging of SQL database tables with MSSQL Express?
There is a modification project in our Process Plant related to SCADA application (Process Automation System) and I am looking for reliable advice/ suggestions from experienced members related to SQL ...
0
votes
0
answers
54
views
Scripted daily SQL dump from Oracle 19.c to SQL Server 2016
I have an SQL user to an Oracle 19c instance, without access to the server's operating system.
Secondly, I have an SQL user to a SQL Server 2016 instance, and a Remote Desktop user.
Both servers live ...
0
votes
0
answers
79
views
MS SQL Server: How to sync multiple local database instances to single central instance?
I have let’s say 3 local database instances deployed at 3 different geographical locations around the world.
I want to sync all these three local instances to one central instance deployed at yet ...
- 121
0
votes
1
answer
95
views
Question on Long-Running Transactions and Secondary Replica Visibility
I have an Availability Group (AG) setup and tried simulating a long-running transaction on the primary. Here’s what I did:
On the primary replica, I ran the following commands:
BEGIN TRAN;
INSERT ...
0
votes
1
answer
118
views
How can I isolate sensible information from a publicly accessible database?
I am working for a medical private practice, and we are planning to install an appointment booking system via our webpage.
The appointment system is a PHP application storing its records in an SQL ...
- 3
0
votes
0
answers
48
views
SymmetricDS time-based sync
I'm trying to configure time-based sync on SymmetricDS, currently I'm using trigger based sync for PostgreSQL to Oracle, but since it's overflowing the database on insert, updates there's another ...
0
votes
0
answers
74
views
Always on availability group removing nodes
We have a SQL 2014 enterprise with 4 node availability group database with 2 Synchronous commit , 1 read only Asynchronous for reporting and 1 DR asynchronous.
Due to space shortage we need to remove ...
- 1,117
0
votes
1
answer
59
views
Pseudo-replication from read-only cloud SQL database to local SQL copy
A vendor has provided us with read-only access to a cloud SQL (2014) database for reporting purposes.
We originally built some local reports off this database directly, but that proved too slow and ...
- 10.1k
0
votes
1
answer
428
views
Synchronizing two databases on different servers
I have two databases on different servers. Each one of them contains 350+ tables and users have read and write access on both databases.
I want to synchronize them, but in special cases, like if a ...
- 101
2
votes
1
answer
1k
views
Understanding SQL Server Availability Groups: Automatic Seeding of Databases
I'm delving into SQL Server Availability Groups (AGs) and have come across a fascinating feature that seems to simplify the process of setting up replicas – the concept of automatic seeding. From my ...
- 2,126
0
votes
2
answers
218
views
How to handle two separate databases? MongoDB and PostgreSQL
We currently have a Postgres database which acts as our core/primary database for our web platform. This database stores registered user accounts (people who have signed up for an account on our site) ...
- 11
0
votes
0
answers
235
views
How can I connect SQL Server to MongoDB for Real time data replication?
You will find three tables. Restore those in MSSQL with a db name "source_db". Create a database in Mongodb named "warehouse_db". Now we need to see,
for any INSERT/UPDATE/DELETE ...
4
votes
1
answer
1k
views
What are the performance implications of using checksums vs change tracking for SQL Server
Back in the day, an implementation with checksum_agg was made to check if "something changed" in a table in a SQL Server table, to then make updates in another database. The users want to ...
- 143
0
votes
1
answer
218
views
Can we do incremental sync of MongoDB based on a schedule?
Can we sync a mongodb database to another incrementally based on a schedule? Say, once every night at 12 am?
Background:
We have a MongoDB replica cluster consisting of 3 instances, all located within ...
- 133