Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [data-synchronization]

186 questions
29
votes
4 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
  • 315
  • 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.
  • 22,196
  • 3
  • 34
  • 78
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 Johansen
  • 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

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…
Josefine
  • 2,158
  • 3
  • 28
  • 55
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
  • 5
  • 17
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
  • 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,035
  • 15
  • 51
  • 76
4
votes
1 answer

How do I synchronize rows in tables in remote databases?

I'm actually developing a synchronization tool in vb.net, I have two database that have on each table records field GUID, this field help to have the same PK on both database. On each record there is also a field called lastUpdated, this field have…
Dillinger
  • 141
  • 1
4
votes
1 answer

Checking existence and syncing data with millions of rows

I am developing sms based service platform. In India, we have two different types of routes to send sms - promo & trans. Sms sent via promo route has to be checked against nationally maintained database (DND), which currently holds 231450000 mobile…
Ehs4n
  • 211
  • 3
  • 9
1
2 3
…
12 13