The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
13 views

Connect to MySQL Webserver (not localhost)

I have a problem. And I hope someone can help me or point me in the right direction. I am working on a project and need to sync a MySQL database (running on PHPmyAdmin) with a MS SQL Server. I ...
0
votes
0answers
4 views

WSREP: Requesting state transfer failed: -11(Resource temporarily unavailable)

We have a 3 node Galera cluster. Only one node has "valid" data (gal-1). The other nodes need to sync from this node. I delete datadir and start MariaDB. 160527 14:28:20 [Note] WSREP: discarding ...
1
vote
1answer
17 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. ...
0
votes
0answers
5 views

MS Access - how to specify frontend settings

I would like to set the direction of data pushing of backend end fronend Access files. There is on central backend. There is a forntend for each user. When a user edits his frontend, the ...
1
vote
0answers
32 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 ...
0
votes
0answers
20 views

Two -way replication on the same server

I have an ubuntu server, and I have a mysql with two database. I want to sync these two database (Two way replication) either via php or command line. I have searched a lot, but I cant find something. ...
2
votes
0answers
26 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 ...
0
votes
0answers
20 views

Manual sync between 2 SQL server databases [duplicate]

I will not go in details and explain everything. For some (not good) reason I need to maintain 2 databases synchronized together. The full database schema may be different but not on table I want to ...
0
votes
0answers
17 views

MS SQL data synchronization question

I'm in charge of modifying an application which was intended to run Microsoft SQL Server Compact 3.5. The application must run on a local database during fieldwork when there is no network ...
0
votes
0answers
19 views

What is the easiest way to set up automatic replication of tables/schemas on two PostgreSQL servers?

I have two PostgreSQL database servers, one uses SSD, the other HDD. We struggled with the full SSD disc and we didn't need all the data on SSD all the time so we moved the majority of them to the ...
0
votes
1answer
51 views

Split data across databases/machines

I have two questions about how to partition data across servers. Can I create and connect two or more databases, with the records correctly associated, using only a mapping table stored in a third ...
1
vote
0answers
65 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 ...
0
votes
1answer
32 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 ...
0
votes
0answers
233 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 ...
1
vote
1answer
79 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 ...
1
vote
0answers
32 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 ...
3
votes
0answers
32 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 ...
4
votes
1answer
85 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 ...
0
votes
0answers
39 views

Syncing DB's between local and live server?

I need to sync two tables between MySQL databases. I have read about MySql Replication. But not sure whether it can be used in this scenario. What I want to achieve is explained below. There are two ...
1
vote
0answers
22 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 ...
0
votes
0answers
26 views

Slony PostgreSQL replication from Chile to US (between datacenters)

We are moving from a datacenter in Chile to one in AWS (in USA). We've already moved most of our servers but the database (PostgreSQL). As the source server is in a VMWARE environment, we took a copy ...
1
vote
1answer
24 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
2answers
51 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
1answer
590 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 ...
1
vote
0answers
65 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 ...
0
votes
2answers
33 views

Replication Setup what's the value of MySQL auto_increment and offset in my.ini

I have setup master master MySQL replication to sync changes in both servers. Now I want to setup 6 servers, is that possible? I'm making 6 because when an area lost it connection over WAN it will ...
0
votes
0answers
36 views

postgres: async statement based replication?

I've noticed that all SBR replication solutions listed on PG site are also synchronous. Is it a mere coincidence? Can there be an async SBR? e.g. a statement is received by a master (or some ...
6
votes
2answers
580 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 ...
1
vote
2answers
218 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 ...
2
votes
1answer
57 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 ...
0
votes
0answers
35 views

Mysql, best synchronization option

Hope the question isn't too vague. I have a user who has a HOSTED web application that helps run his day to day business. The application is very useful to the client and his customers, as they can ...
0
votes
1answer
193 views

How to setup sync between MongoDB and C# .NET Application

What is the best practice to synchronize a MongoDB remote database with a C# .NET App that would allow queries to be responded to within the local file system and update itself when there is a change ...
0
votes
0answers
187 views

How to synchronize same table in two MySQL databases

I have two databases with same table name and scheme. For short, let's assume that both have ID, Name, Surname columns. Database1 is a production one and deleting lossing data from its table is not. ...
1
vote
0answers
183 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
1answer
51 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 ...
0
votes
1answer
88 views

SQL Server 2012 AlwaysOn Availability Group

We have an application that needs access to the database all the time to work properly and we are planning on deploying SQL Server 2012 AlwaysOn Availability Groups on Windows Server 2012. We have ...
1
vote
0answers
44 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 ...
0
votes
1answer
36 views

How should I handle unknown primary keys? [closed]

I'm working as a database-administrator at a school. Recently the school upgraded its pupil administrative software into a web-based solution. This works great, but this web-based solution is missing ...
0
votes
1answer
593 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 ...
3
votes
1answer
308 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 ...
0
votes
1answer
37 views

SQL redundant databases both sets being modified independently yet staying concurrent

I have a server in location 1. This location has slow external internet but all the employees. Location 2 has fast external internet but no people are there. I have a mobile app that I would like to ...
0
votes
0answers
52 views

Azure Database Sync with warning on row update

To create a real time backup DB in Azure, I have used the Azure sync group. What I have noticed is that if I edited one of the rows in any table (let's say, the customer's name) , I receive the ...
0
votes
0answers
11 views

Monitoring external Oracle db, creating changes locally to SQL Server

I have a local mirror database of an external database that our vendor provides us read access to. Occasionally they add columns and/or table to their database. The addition of columns used to play ...
1
vote
0answers
78 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 ...
6
votes
3answers
6k 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 ...
1
vote
1answer
240 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 ...
2
votes
2answers
1k 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 ...
0
votes
0answers
30 views

Synchronization of DB

I have 2 databases and I need to synchronize data between them. I need to delete all the data from DB1 and then insert data to DB1 from DB2. What solution will you suggest drop all the foreign ...
0
votes
1answer
133 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
0answers
180 views

Sync offline database with online

I have a rails application which is currently running on cloud. We want to serve our application to rural locations where Internet is not available. We will be deploying our rails application on local ...