Questions tagged [data-synchronization]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
106 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
525 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
985 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
96 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
442 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
50 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
630 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
227 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
552 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
757 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
248 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
2answers
54 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
42 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
793 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
847 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
37 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
886 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
848 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
23 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
449 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
68 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
52 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
159 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
167 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
92 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
1k 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
65 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
237 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
422 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
620 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
213 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
85 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
225 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
3answers
58 views

Sync between two database on azure

I would like to ask a question how to setup azure syncing of two database on azure i need real time data replication to the other database
0
votes
1answer
25 views

Load data from a temporal table to another temporal table in Azure

Currently we have only a Live Database where all our data resides. I have created a separate Azure server and DB for development. The DEV DB should be some what up to date with the Live DB for ...
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 ...