Stack Overflow
Stack Overflow

Questions tagged [symmetricds]

SymmetricDS is open source software for both file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment.

SymmetricDS is open source software for both file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment. It supports multiple subscribers with one direction or bi-directional, asynchronous data replication. It uses web and database technologies to replicate data as a scheduled or near real-time operation. The software was designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.

296 questions
0
votes
0 answers

Symmetricds syncronization between ms-sql and mysql

The task is to synchronize data from a ms-sql to a mysql near real-time. I just found out about symmetricds and I am asking myself if this is possible with symmetricds. To setup db connections (one ms-sql, one mysql) and synchronize changes on the…
Gabriel Stein
  • 428
  • 1
  • 4
  • 22
0
votes
0 answers

How to diagnose problems (Failed to route and batch data on XXX channel)?

I am using SymmetricDS and i have stumbled across a problem on one of my clients. Log says: 2015-11-11 09:10:57,688 ERROR [blagajna_XXX] [RouterService] [blagajna_XXX-job-17] Failed to route and batch data on 'cFpromet'…
gregaj
  • 328
  • 1
  • 6
  • 15
0
votes
0 answers

symmetricDS server (postgresql) client (mysql) setup allowing send table schema ignoring FK constraint

I would like to setup following scenario: server (postgres) is replicated life to client (mysql). Only one direction. I am trying to build this setup using symmetricsDS. The problem occures when I try to send table schema to client node. It always…
andilabs
  • 22,159
  • 14
  • 114
  • 151
0
votes
1 answer

status of client is open not registered

Hello I am working on android project with sqlite database. I am using Symmetricds pro for the replication between client and server. status is open but not registered at server side and there is no option to allow registration. May I know…
srikanthg
  • 71
  • 1
  • 8
0
votes
1 answer

SymmetricDS conditional sync

I need to set up conditional sync via SymmetricDS. I know I can use columns to determine if the entry is being synced, but I need to determine it via external table. Is there a way to do that? I.e. I have entries with project_id in one table, and…
SMSk
  • 693
  • 8
  • 25
0
votes
0 answers

error 8 [failed second stage] with native error 16

i have installed symmetricds 3.7.23 version. when i click on start server button. I am getting the following error message. error 8 [failed second stage] with native error 16. please can any one tell me why i am getting this error?
srikanthg
  • 71
  • 1
  • 8
0
votes
1 answer

Modifying CURRENT_TIMESTAMP per Firebird database

I have many databases on the same server, representing different time zones in each one (pacific, mountain, central and eastern). Right now my programs use things like 'NOW' and CURRENT_TIMESTAMP to get the current time for the records. This is a…
user2085722
  • 43
  • 6
0
votes
1 answer

Connect SymmetricDS to ParaSQL

We're trying to test loading data from our on-premise SQL Server 2008R2 machine to ParaSQL using SymmetricDS. We have a dedicated server instance with ParaSQL which requires an SSL connection. Certificates are provided by ParaSQL. Where we're stuck…
Koen van Wielink
  • 67
  • 1
  • 10
0
votes
0 answers

Fetch Foreign Key Row Data With Sync

I am using SymmetricDS for first time and i have two table to sync. 1. Session_Tbl :- this table sync from Store to Corp. I cant make session_tbl bidirection. 2. Products :- This table sync in bidirection. Product Table is linked with Session_tbl…
Anchit Pancholi
  • 1,174
  • 4
  • 14
  • 40
0
votes
1 answer

Conditional sync with SymmetricDS

I've been trying to make a conditional sync with SymmetricDS. Problem is, no matter what I do it just ignores the table that is supposed to be synced conditionally and just syncs tables without conditions. So I suppose, I use those conditions…
SMSk
  • 693
  • 8
  • 25
0
votes
2 answers

How to use symmetricDS in Embedded mode

I have the following use case: A database A (Master) and a database B (slave), located on diferent machines. I want to synchronize the Database A with Database B. I want to create a java application using SymmetricDS embedded. As there is no…
Mohamed Mekdad
  • 103
  • 1
  • 11
0
votes
1 answer

SymmetricDS : How to synchronize the raws which before symmetricds installation

I have a database run 4 months already. It only can synchronize raws after symmetricDS installed. Is it possible to synchronize raws include data before symmetricds installation. How to do it?
eagle
  • 11
0
votes
1 answer

Symmetric ds system could not found the path specified

I am working on an application for data replication using SymmetricDS. I have set my configuration in both master and slave machines, which are as per the SymmetricDS specifies in its sample example. But when I install the SymmetricDS it shows…
Kamal Singh
  • 990
  • 8
  • 13
0
votes
1 answer

SymmetricDS: change operation from update to insert/delete in a table transformation

on my source table i have a boolean column and if the boolean is switched on SymmetricDS should insert a row into my target table. If it was switched off it should the (eventually) inserted row from target table. After reading the Documentation…
Markus Schulz
  • 500
  • 5
  • 12
0
votes
2 answers

Symmetric DS schema versioning

I have a server and few clients with databases sinchronized by Simmetric-DS. Now the database version is 1.0 for client and server. So the column node.schema_version is 1.0 for clients and server. I can upgrade the server database manually to…
Mario Di Ruscio
  • 21
  • 5
1 2 3
…
19 20