Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [data-synchronization]

201 questions
34
votes
5 answers

Sync two MySQL databases in two different locations

I have two identical MySQL databases one in an internal server and the other in a web hosting server. I want to update the database on the web host each day with the database on the internal server. Is there a way to automate this process also how…
ry12
  • 365
  • 1
  • 3
  • 5
17
votes
5 answers

Syncing two databases in SQL Server

I have two SQL Server databases. One is client (Windows application) and the second is on the server. I want to sync these two databases every so often (e.g. every 2 minutes!). I have read about different ways of syncing like replication, time…
Emad Farrokhi
  • 193
  • 1
  • 1
  • 7
11
votes
1 answer

Synchronization using triggers

I have a requirement similar to previous discussions at: Writing a simple bank schema: How should I keep my balances in sync with their transaction history? Trigger in combination with transaction I have two tables, [Account].[Balance] and…
Yiping
  • 227
  • 2
  • 8
7
votes
3 answers

Scaling out SQL Server and syncing data across multiple machines

I don't have expertise in architecting databases, and I've been teaching myself new stuff every day. I'd like to make an Internet-scale application using SQL Server as the data store. I haven't found any good information online with regards to…
Mark13426
  • 579
  • 1
  • 7
  • 11
7
votes
1 answer

Is there a way to determine what kind of data is sitting in the Redo Queue for an AlwaysOn AG Secondary Replica?

Do any of the DMVs or is there another way to expose what kind of data is in the Redo Queue that's in process of being synced up to a secondary replica? (E.g. is it table data and which table, or is it index changes and which indexes, etc?)
J.D.
  • 40,776
  • 12
  • 62
  • 141
7
votes
2 answers

Instant synchronization of multiple SQL servers

First of all, I am sorry if this is a duplicate. I was unable to find anyone who adressed this particular question, or I might have failed to realize it as I read it. Most likely I used the wrong search-phrases, as I am not all that familiar with…
Levi
  • 360
  • 1
  • 3
  • 13
6
votes
1 answer

Best database replication technique for a very unstable (power wise) network

I am part of a small network (500 users) who are all connect via WiMax to each other. The people connected to this network live in about a 70 km radius. This network allows for a transfer speed of about 1.5 MB/s. We are using a website which uses a…
Gatkramp
  • 61
  • 1
6
votes
1 answer

sync MS SQL Server 2014 and Express 2014 Database using Stored Procedure

I have C# windows form application and I have same database schema on both MS SQL Server(for master user) and on SQL Express(for clients). My database size is around 2 GB for each client. I want to synchronize this databases once in a day. In MS…
Jaimesh
  • 111
  • 4
5
votes
1 answer

Setting up cloud database for syncing to local SQLite database

Background I have a SQL Server database hosted on AWS RDS and there are web applications and WEB APIs that talk to the database. The database is a multi-tenant database and we are currently using SQL Server 2014 although we can upgrade if…
keithm
  • 151
  • 1
  • 4
5
votes
1 answer

MongoDB replication: going into maintenance mode with 10333 other maintenance mode tasks in progress

I have a MongoDB instance where resync is required. 2016-11-07T11:59:23.330+0000 I REPL [ReplicationExecutor] syncing from: x.x.x.x:27017 2016-11-07T11:59:23.354+0000 W REPL [rsBackgroundSync] we are too stale to use x.x.x.x:27017 as a sync…
Sybil
  • 2,578
  • 6
  • 34
  • 61
5
votes
1 answer

Very slow merge replication synchronization

I had an unforeseen issue with a sub going down (generic error, was probably a connection issue) and now that I've reconnected the sub it is insanely slow re-syncing. It seems to download about 1000 changes then sit there for about an hour before…
tmwoods
  • 145
  • 1
  • 10
5
votes
1 answer

How to manage primary key value while multiple secondary server sync with primary server?

we have three secondary database server in different cities and one primary server. my question is i want asynchronous transaction commit to all three database but primary key data conflict occur when commit to primary database...because same id…
Gulrez Khan
  • 363
  • 1
  • 7
  • 20
4
votes
1 answer

MongoDB can't add new replica set member [rsSync] SEVERE: Got signal: 6

I have a replica set and I added a new member to the set. The initialSync begins for the new member and rs.status (on primary) shows STARTUP2 as status. However, after a long enough time, there's a cryptic fassert error coming on the new instance.…
VaidAbhishek
  • 253
  • 1
  • 3
  • 10
4
votes
1 answer

Sync postgreSQL with SQL Server database- on data change event

I have one PostgreSQL database and its data are being changed regularly. I want to sync all its data with my SQL Server database. One thing I can do is use query to check all required tables and columns whether data is same or changed. If changed,…
IT researcher
  • 3,168
  • 15
  • 59
  • 82
4
votes
1 answer

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 get the changes across between the systems quickly, so the…
Ola Eldøy
  • 143
  • 4
1
2 3
…
13 14