Questions tagged [data-synchronization]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
16
votes
4answers
103k views

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. ...
12
votes
4answers
59k views

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 ...
10
votes
1answer
4k views

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 ...
7
votes
2answers
2k views

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 ...
7
votes
3answers
3k views

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 ...
6
votes
1answer
551 views

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 ...
6
votes
1answer
349 views

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 ...
5
votes
1answer
2k views

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]...
5
votes
1answer
583 views

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 ...
5
votes
1answer
3k views

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 ...
4
votes
1answer
159 views

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 ...
4
votes
1answer
786 views

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 ...
4
votes
0answers
268 views

Merge replication subscriptions are repeating the same actions endlessly

We have a merge publication set up on SQL Server 2008R2, with several subscribers. Synchronisation is done through the internet. Over the last few days, some subscribers are unable to synchronise. ...
3
votes
3answers
6k views

How to synchronize two MySql tables using command line

I have two tables in the same database (MySql) where one has been populated and there are data been added to it frequently. I want to have the data added to the first table to be present in the ...
3
votes
1answer
2k views

Data synchronization across multiple databases

I have a Django application which uses PostgreSQL as a database. The application stores hierarchical data. It is like a warehouse management system with multiple branches and hierarchy. The current ...
3
votes
2answers
680 views

How do I set up Azure Sql Server to have multiple instances?

We are setting up a new SAAS application on Azure and while we have used Azure before, not at this level of multiple apps, etc. We plan to have both a web app and a cloud app in both a US and EU ...
3
votes
2answers
3k views

MySQL Master-Master Replication not syncing

SETUP: I have a WAMP MySQL Master-Master replication setup on 2 machines with sync_binlog=1 for safety. Machine config: Windows Azure Standard 2: 2 core, 4GB RAM, Windows Server 2008, MySQL 5.6.12, ...
3
votes
1answer
5k views

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 ...
3
votes
1answer
2k views

Syncing a SQL Server table with a CSV file

I have recently started a project with sensors that add data to a single CSV file as data the data. I would like to have this data stored in a SQL Server database in a relatively real-time manner. I ...
3
votes
2answers
6k views

Sync many client database to one central database

We have client application which can be installed on local machine where users can work offline and create projects in it. This application is already developed. Now we need to create Admin ...
3
votes
1answer
920 views

Live Database Sync. MySQL - SQL Server [closed]

I have a rare scenario. Is there any possibility to achieve the target? Here is the situation: I have developed a responsive site for a supermarket. I am using php with foundation framework and the ...
3
votes
0answers
2k views

MySQL along with Firebase for data sync

I'm currently working on a mobile app powered by a web platform, and the mobile app will have some offline capabilities. The application has a small amount of DB entities, and only about 3 of them ...
3
votes
1answer
980 views

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 ...
3
votes
2answers
1k views

Syncronize mysql databases between local and hosted servers automatically

We have many websites with Development, Staging and Production servers. We have many developers for many projects. We need a solution to synchronize the developer and staging databases. After that one ...
2
votes
2answers
1k views

Post Mortem Analysis: PostgreSQL replication failed

We have a PostgreSQL 9.4.9 production server which was replicating to a slave instance, but today I discovered that the instance is out of sync! The obvious actions would be to recreate the slave, ...
2
votes
1answer
7k views

How can I synchronize data between two RDS MySQL databases

I have 2 Amazon RDS MySQL instances, one is MySql v5.5 and the new one is 5.6. I want to upgrade the 5.5 to the 5.6 but you cannot do upgrades at this time, so we are trying to migrate the data. I ...
2
votes
1answer
6k views

Offline to Online database synchronization programmatically using PHP and MySQL [closed]

I am working on a project in which the client requires an online as well as an offline application. Offline application data will be manually synced to online database linked to the web application. ...
2
votes
2answers
3k views

Sync two databases on different servers

I can't pick the right solution for my below requirement. Can you people please advise? We have two SQL Server 2012 database servers: First one is in Texas (USA). Our client will use this for UAT. ...
2
votes
2answers
4k views

org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery

I currently have a PostgreSQL slave node that is presenting problems, that don't arise in the master node. Seems to be related with the node sync process. Complete stacktrace: org.postgresql.util....
2
votes
1answer
1k views

Sync & Async Synchronisation on SQL Server 2012

Is it possible to set up async synchronisation (high-performance) on MS SQL Server 2012 globally, but somehow force synchronous replication for one table between nodes? Nodes are in different subnets/...
2
votes
1answer
615 views

SQL server: create local copy of remote table

I have read access to a remote SQL Server that contains table 'dbo.myTable'. The problem I am facing is that it is slow to read the data remotely, especially for small frequent calls. I also have a ...
2
votes
1answer
2k views

How to Sync a MySQL DB with a Oracle DB?

I have access from 5 views of an Oracle DB located outside of my organization. I need to sync my db that is a mySQL DB with the oracle DB (Oracle views will be the master, my db will be the slave). I ...
2
votes
1answer
561 views

Using the output from mysqldiff.exe to transform database2 to match database1

This question is related to another I had asked earlier here: Passing passwords more securely to mysql utilities on the command line. I have recently been trying to use mysqldiff.exe, part of MySQL ...
2
votes
1answer
1k views

Best practise how to sync SQL Server 2014 database with other database

What is best practise if we have application using a SQL Server database and we would like to have backup if SQL Server does not work? Our scenario: We would like to use our main SQL Server database ...
2
votes
1answer
550 views

Efficient join technique for two very large tables

I am working on a concept for database synchronization recently. The scenario is as follows: there is a master table "Items" with 1M+ rows in it CREATE TABLE [dbo].[Item]( [Id] [...
2
votes
1answer
562 views

Incremental sync for Sql Server

The Change Tracking feature of Sql Server allows to identify the modified rows of a modified database copy. This is obviously helpful for sync jobs, as the database can then be synced incrementally. ...
2
votes
1answer
61 views

Oracle strategy

I would like to ask you to help me with following situation: I have 2 servers. One is production and secondary is backup. Both are in 2 different geographical localizations. Switch between them in ...
2
votes
1answer
295 views

Postgres: Merge database backup with development database

My database is quite large 50GB+ what I've always had to do when I want to sync my development database with production is download a backup of production, drop my development database then restore ...
2
votes
1answer
561 views

federated tables? synchronization? replication? [mysql]

I have a REMOTE suppliers' table with, let's say, a code and a name, and several client databases will be creating new suppliers. Server database code | name ------+------- 1 | Mark 2 | ...
2
votes
1answer
570 views

Sync MySQL database and Quickbooks Database

I use Quickbooks as an accounting software. I also have a MySQL database where I record data on orders, customers, inventory, employees and etc. Is there a way for me to sync the two databases? For ...
2
votes
4answers
895 views

SQL Server: Database integration and synchronization

I have n SQL Server databases with the same data schema. On the other hand i have a web application that needs to retrieve, for some entities, the union of the information stored into the n databases....
2
votes
1answer
6k views

Synchronize MySQL databases between local and hosted servers

I'm developing a software in Microsoft Blend and I need it to be synchronized with my online server MySQL database. I have local MySQL database which I use for the app. The app also have an online ...
2
votes
0answers
66 views

Replacing full contents of SQL tables without user disruptions

I have a SQL Express 2012 DB in which there are tables that need frequent full "refreshs" (on-hours) from an external source without any disruption of the users. Let's say the tables are Item, ...
2
votes
0answers
52 views

Periodically synchronise databases on 2 different servers

On my main development workstation I have around 20 databases. Every so often I will work from home on my laptop instead, where I also need a copy of these databases. Because working from home is ...
2
votes
0answers
122 views

Distributing MS Access Database

I develop an application that saves records in MS Access DB. Each user has it own DB copy on his local machine, and there is a central DB that reflects all the copies from everyone. The central DB is ...
2
votes
0answers
43 views

Asynchronous Availability Group Secondary Verify Up To Date with Primary Before Backup

I was wondering if there was a way to include a verification step before a backup on a secondary replica under asynchronous commit mode in availability groups to verify that the secondary replica is ...
2
votes
0answers
43 views

Bandwidth-efficient, fail-safe database resync with long backlogs

I'm looking for a DB system that allows slaves to resync even if there exists a long backlog. In addition these resyncs must be as bandwidth-efficent as possible as the nodes are connected over GSM/...
2
votes
0answers
169 views

Keep selected tables synchronized across MySQL databases

I've a need that requires me to keep a number of tables from a database (db1) synchronized with another database (db2). db1 & db2 have different structures and a set of tables and their data from ...
1
vote
2answers
551 views

Azure SQL Database in different locations

I'm deploying a Sitecore website using Azure and Azure SQL, and one of the requirements is to have some of the databases in different Azure Regions but sharing the same data among the other databases. ...
1
vote
3answers
3k views

How to auto replicate specific columns only from a table in MySQL

I want to make one master DB which replicates specific user data into other databases such as: username pass (hashed) email pin (hashed) timezone (int) They are all in one table and running on ...