Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data-synchronization]

The tag has no usage guidance.

1
vote
1answer
101 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 ...
1
vote
2answers
372 views

What are possible ways of handling multiple users accessing the same database via custom web API? [closed]

I am very new to databases and Web design, but I understand enough to know that designing a good database is crucial, so I would like to prepare for that conceptually. However, I was unable to find ...
1
vote
2answers
941 views

Are expdp/impdp commands appropriate for daily schema sync?

I've done following comands: expdp system/password@localdb ^ schemas=SCH directory=dumps_dir dumpfile=SCH_%date%.dmp logfile=expdpSCH_%date%.log It runs great, without errors. But when I use command:...
1
vote
1answer
93 views

Sync data in SQL Server 2014 with Oracle database12c

I have installed Oracle database 12c enterprise on my laptop. How can I implement data synchronization between Oracle 12c and SQL Server 2014 that whenever an INSERT,UPDATE,DELETE or ... happend on ...
1
vote
2answers
1k views

Sync 8 tables of differents databases on same server

I will use eight wordpress websites and i need to sync ther wp-user tables so each single user can connect through all websites. All of these will be on the same server, using the same MySQL user, but ...
1
vote
3answers
358 views

Mysql master-master: single table out of sync

I have a master-master MySQL 5.7, everything works fine except for one error which is rising from time to time. If I run a show slave status\G on server2 I have an error on a table: ... Last_Errno: ...
1
vote
2answers
49 views

Aggregating high volumes of data from many MySQL servers

I have 4 servers of MySQL, each receives around 4 million records a day. I need to aggregate all the inserted records into another main server after doing some mapping processing to the aggregated ...
1
vote
1answer
601 views

How can I synchronise Always Encrypted data from On-Premises to Azure SQL Database (near real time)?

Let's say I have On Premises SQL Server 2016 SP1 and Azure SQL Database. There is no way at this point to redirect whole solution directly to Azure SQL Database and I need to have a copy of the ...
1
vote
1answer
218 views

Merge Replication customize synchronization cycle and its performance

I'm trying to implement Merge Replication between just two servers, a publisher and one Subscriber. Assume these tables : --Main table in Publisher Ticket (id, userId, reqId, blockedDate, usedDate, ...
1
vote
1answer
511 views

Best solution to keep a big table synched in 2 DB

I manage a few tables with more than 1 billion records. Daily, their ETLs run, reading data from flat files and inserting a few thousand records on each of them. Now I need to keep these same tables ...
1
vote
1answer
747 views

Oracle 11g Sync Standby Database

Currently, I synchronize the standby database from primary database by copying archive logs from primary server to the secondary server. I do this activity daily. I have heard that there are automated ...
1
vote
2answers
242 views

MySQL: How to sync on demand beetwen two database in the same server

I'll like to know if it's possible to have a systeme on synchronisation beetween two database in the same server. I have a production database in my server , i want a dev database (same database with ...
1
vote
1answer
1k views

Automatically generate ALTER TABLE to syncronize schema on PostgreSQL

i Have 2 different database schema in PostgreSQL sql file from pg_dump, is there automated way to generate alter table commands so it would be in sync, without inspecting one by one? this is the ...
1
vote
1answer
47 views

Automating Redshift data dump to a PostgreSQL DB every hour

GIS analyst with minimal experience of this back-end stuff but a big task at hand. I have a redshift database that changes multiple times a day. I want to use this "live" data to make web maps and I ...
1
vote
1answer
39 views

What's the correct behavior for mongoDB when mongo hosts in two DC can't talk to each other

Let's assume there are two data centers: DC1 and DC2. In DC1: Two mongodb hosts, one primary, one secondary. All mongo hosts in DC1 have the readPreferenceTag: dc:"DC1" Two app host, the ...
1
vote
1answer
2k views

SQL Server AlwaysON : start sync with secondary for selected databases

I have an SQL Server 2012 AlwaysON cluster composed of : win-mssql1 : witness file share win-mssql2 (INSTANCE 1) : primary server win-mssql3 (INSTANCE 2) : secondary server Recently I had the ...
1
vote
1answer
43 views

Sync while Restore Operation

I am trying to restore the Latest content to one of my Primary Replica Database which is part of AOAG. My question is during the Restore operation, 1) Will the synchronization still happens between ...
1
vote
1answer
734 views

Sync two mysql database one in intranet and the other on internet

I'm making the training and placement module for my college. But I'm facing problems to sync the databases, one that will be used by the students and the other that will be used by the HR of a company....
1
vote
1answer
1k views

Syncing data from primary member to secondary after election

Maybe this is kind a stupid question but, I'm novice in configuring replication and I need to clear something before makeing anything else. Moment ago I configured replica set with 3 members in it. ...
1
vote
1answer
829 views

Synchronize MySQL database from remote MySQL database

The documentation mentions a sync function, but that function is not available from the Database menu as shown in the screenshots there. Is this functionality available elsewhere? Using reverse ...
1
vote
1answer
36 views

Synchronizing two MySQL Server both serving clients after reconnect

I am not a pro in DB...here is my case. I have 2 MySQL databases on ServerA and ServerB and clients in 2 buildings, with only network connection between them and no more outer network available. I ...
1
vote
1answer
3k views

DBClientCursor::init call() failed

During syncing a slave(SECONDRY) node, I have DBClientCursor::init call() failed error and it's start syncing from scratch, the full log is provided: Tue Nov 10 05:54:56.281 [rsSync] clone xxxxx....
1
vote
1answer
3k views

Synchronise Oracle Tables to SQL Server

Our ERP is using an Oracle database while our BI system is based on SQL Server. We need to get the changed data in Oracle and copy it in our staging area. At the moment we get the changed rows by ...
1
vote
4answers
1k views

Script to merge-replicate two MDF database files?

I have a program on a computer and on a tablet. The program uses SQL Server Express to interact with a local database (the same information on both) from a .MDF file. So if I plug the tablet into the ...
1
vote
1answer
884 views

MySQL Database replication for high availability

configuration: 1 balancer 2 Azure machines(4 gb ram, 2 cores), with MySQL master-master replication enabled. X users connecting to the balancer to sync data. test: i've tested the MySQL replication ...
1
vote
1answer
822 views

Data Sync between servers with different schema in SQL Server [closed]

I have two servers 2008 R2 and 2005. The e-commerce site has been running with 2005 Server. I have migrated 2005 server data with modified data schema to 2008 R2 from yesterday's date of data. My ...
1
vote
1answer
141 views

Clarification on Cloud Computing Database

This question can be very generic, but I am trying to understand the concept of Cloud Databases. Let's say I have a Web Application, a Desktop Application, and Apps for my Web Application. All of my ...
1
vote
1answer
22 views

Backup weekly current production db to Historical db server [closed]

I have a production sql db of 600gb and a historical server where i move the full db every month. Now we want to have only the last 3 months information on the production server, and move every week ...
1
vote
0answers
394 views

SQL Server One Way Data Synchronization

I have 2 SQL Server Databases A and B, and I want to synchronize (continuously, every 10 minutes, max) the data from 70-80% percent of the tables from A to B (just A -> B, B is a read only database), ...
1
vote
0answers
61 views

Synchronisation of multiple databases with GUID type

I have two databases. One is on mobile and uses SQLite and another one is on Microsoft azure. I want to sync data in both directions. Sometimes some data is saved on azure db and should be ...
1
vote
0answers
49 views

data synchronization between two dbs

I need your help on some replication matter I guess. I'm actually not a dba, but I need to do some work on my db: I have a remote db, with table1, table2 and a local db with table3 and table4 in local ...
1
vote
1answer
145 views

Partial SQL Server database synchronization [closed]

I have 2 SQL Server databases and they have somewhat different schemas. But there is a table with person attributes. Name, address, city, email, etc... And an account key. on both tables. Can SQL ...
1
vote
0answers
40 views

Table sync without admin rights

I have a client that really (really, REALLY!) wants to use a standard database server through a specific hosting company. That company offers vanilla installs of PostgreSQl and MySQL only. The client ...
1
vote
0answers
160 views

Sync data from tables in two SQL Servers

In a following app arhicecture, local C# desktop app with SQL Server Express, which need to work offline sometimes and a central web app with SQL Server Enterprise, with db per local app. I need to ...
1
vote
0answers
91 views

PostgreSQL Single Mode Command

I've been working for a while with PostgreSQL and I managed to find out a way to use pg_rewind function in order to resynchronize an old master after a new promoted master (old standby). (using repmgr ...
1
vote
0answers
996 views

Synchronization between MS-SQL on premise database and azure database

Is there any stable way to synchronize a table between a MS SQL Server on premise database and a table in an Azure database? So far i have found the following possibilities, but they are not stable: ...
1
vote
0answers
74 views

How to sync incomplete replication records in MySQL

if replication breaks and you end up with a couple of records not pushed out to the slave, is there a way to update the slave without stopping locks on the master and manually transferring a new ...
1
vote
1answer
64 views

Syinc databases mySQL to Oracle

I'm new in "databaase administration" the problem I am facing is that I want to have an exact copy of a table, from MySQL database (website database) to oracle database (a local one). What I've done ...
1
vote
2answers
224 views

Sync data between 2 databases Oracle 10g

I have 2 databases DB_LIVE and DB_NEW, both have different credentials. I have a Data Read access on DB_LIVE and I am owner of DB_NEW which is a completely blank and raw db provided to me. I want to ...
1
vote
0answers
395 views

Is it possible to synchronize multiple databases in to 1 database with the same tables?

We are facing a situation where we have 5 different businesses with comparable data and are building 1 single application to deliver their data to common customers. In order to do this, the plan is ...
1
vote
0answers
602 views

Update remote MySQL database upon changes in local SQL Server database

I have a Web store running with MySQL on the remote host. And I have inventory management software using Microsoft SQL Server on my local system. I want to update product stock in the web store when ...
1
vote
0answers
200 views

Database sharding, denormalization and synchronization

In sharding, it is advisable to follow a share nothing, shard everything approach. Essentially, this translates to: data that are to be used together are to be stored together (i.e. in a single shard)....
1
vote
0answers
84 views

Replicaiton and synchronizing to a central database

My client will have many outlets and each outlet will have a local db. But there is only one outlet which will have a central db. Ideally, my client wants to put everything on a cloud but due to the ...
1
vote
0answers
224 views

Sync/Replication of 2 Oracle Databases with NetApp storage

I am working on a high availability setup of Oracle Enterprise Manager. I need the back-end repository replicated (preferably in real time, or something close) to another repository, in which I could ...
0
votes
2answers
39 views

Keeping database in synch

This might seem like a stupid question. Can i restore logs of one database to another existing database of same schema.? I have a database d1 in Server A.I took backup of that and restored as ...
0
votes
4answers
1k views

Sync two SQL Server databases

So I've got a hosting package from hostgator with an MS SQL database and a local SQL Express 2012 database running. I'm trying to investigate syncing the two together, two-way syncing, and I'm unable ...
0
votes
2answers
3k views

Linked Server : Syncing two tables on two SQL Servers

Suppose these database structure : --On main server(server) TicketRequest (id, date, count, start, end/*,and some other columns*/) Ticket (id, reqId, blockedDate, usedDate, userId/*,and some other ...
0
votes
1answer
1k views

Importing data from MS Access database to an existing Postgres database

I'm developing a Django based website with a Postgres DB. The problem I'm having is importing the data from an Access DB into it. To be specific, I'm not trying to translate/import the schema from ...
0
votes
1answer
24 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. ...
0
votes
1answer
44 views

How to insert data from a local MSSQL db table to a remote MSSQL db table using WCF application coded in .NET [closed]

I made a WPF application using VS2013, coded in .NET. It is working fine in my local SQL Server. But I want to use it to upload data from a local database to a remote database. How can I do this? I ...