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
1 answer

Foreign key error on MySQL

I have two tables and try to create foreign key constraint, and I get an error: [SQL] ALTER TABLE `defectstdreference` ADD CONSTRAINT `Relationship72` FOREIGN KEY (`improve_notice_doc_id`, `defect_id`, `client_id`) REFERENCES…
SMSk
  • 693
  • 8
  • 25
0
votes
0 answers

Log connections to SymmetricDS

I have the following setup: server and client nodes are deployed to Tomcat with item channel set to 0 on client. Everytime user presses a button that channel is set to 1, I wait till it synchronizes all and then set it to 0 again. I need to create a…
SMSk
  • 693
  • 8
  • 25
0
votes
0 answers

Any SymmetricDS replacement framework?

We were using symmetric DS for database replication, but we are checking if there's any other tool or framework which can do the same thing. We want application level database replication, not db level, because db level need do a lot manual…
Raysen Jia
  • 369
  • 4
  • 16
0
votes
0 answers

SymmetricDS not syncing database with different timezone

I set-up symmetricds ( version 3.7.3) to sync a few tables from a central database to two client database, the central and 1 of the client(client1) is in same region as the central, while the other client(client2) is on different region. Hence,…
ivanceras
  • 1,415
  • 3
  • 17
  • 28
0
votes
0 answers

Wrong registration url in slave nodes of SymmetricDS

I've recently deployed SymmetricDS tutorial example to my Tomcat 8. I have three .war files created from corresponding .properties files: corp-000.war, store-001.war and store-002.war. The sync.url in corp-000.properties file…
SMSk
  • 693
  • 8
  • 25
0
votes
1 answer

Problems synchronizing two tables in the source to one table in target node

I have this scenario: Source node: Schema1: Table1: id, field1, field2 Table2: id, table1_id, table3_id Table3: id Table4: id, table1_id Schema2: Table5: id, table3_id, table6_id, field3, field4 Table6: id Target Node: Schema1: Table7: id,…
Anne
  • 189
  • 1
  • 4
  • 16
0
votes
0 answers

SymmetricDS Numeric Overflow

I've got 2 databases with the exact same design and I'm receiving an error from SymmetricDS when trying to insert specific records from the Active database to the Passive. I'm getting the following error: 'Numeric overflow in conversion of value 211…
Kaleb
  • 1
  • 2
0
votes
1 answer

SymmetricDS: support for different database stucture and transectional property

I am confused about some property of SymmetricDs. i.e. If the remote and the central database have different database structure (not different database like mysql, oracle etc.), how can we manage it? For example, if the remote database have two…
biqarboy
  • 852
  • 6
  • 15
0
votes
1 answer

SymmetricDS registering the Client from Java Code

I'm using professional version of Symmetric DS(Symmetric DS pro 3.6.13). We are able to add the client to the server but not able to register the client without manual click on “ALLOW” option . We want to register the Client and open Connection from…
user3872682
  • 1
0
votes
1 answer

Lightweight ETL or database Sync - Sybase to SQL Server

I have been doing some investigations into some light weight database Syncing tools to trial. The initial task we want to perform is a simple data sync from a few tables on a Sybase ASE database (15) to a SQL Server database (2008 R2). Timing…
Ash
  • 390
  • 4
  • 18
0
votes
1 answer

SymmetricDS - Only "copy" transformation_type seems to work

I have several transformations to test sync to multiple tables to one table, or one table with several fields to one table with less fields. All that works correctly, however, when I try to change "copy" type to "const" or "bsh" in transform_column…
Anne
  • 189
  • 1
  • 4
  • 16
0
votes
1 answer

How to sync files using symmetricDS Pro and archive it to another folder in source node

I am using SymmetricDS Pro 3.5.18 with 800 store nodes and a 1 corp node only. I have in the store nodes Source folder having "specific files" , I want to send it to corp node in "target folder" and after that I want to move synchronized files to…
user3549399
  • 1
  • 1
0
votes
2 answers

Symmetricds Transform Single Table to Multiple Tables Example

Please provide an example configuration of Transformation of a Single Table to Multiple Tables Practical Scenario: I have a corp node and store node. I have two tables customers and imp_customers in the corp node, I have one table customers in the…
Binyamin Melepat
  • 59
  • 11
0
votes
1 answer

Rows insertion during an initial load leads to synchronization failure. How to prevent it?

I am using SymmetricDS version 3.4.8 to synchronize 2 PostgreSQL DBs. I have encountered the following problem: I have several dependent tables, e.g. 'node' and 'device' tables where 'device' table has FK to 'node' table; if new rows were added to…
Yulia
  • 13
  • 3
0
votes
1 answer

In SymmetricDS file synchronization, Set the target base dir path dynamically by fetching from the database bean shell script

I'm using SymmetricDS for doing file synchronization between client and server node, I want to fetch the file sync target path from my database or file which is different for each client node. I researched about it and find out that we can use shell…
Binyamin Melepat
  • 59
  • 11
1 2 3
…
19
20