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.

270 questions
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
  • 930
  • 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
  • 410
  • 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
  • 1
  • 3
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
  • 643
  • 6
  • 22
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
  • 643
  • 6
  • 22
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
  • 339
  • 3
  • 14
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,305
  • 3
  • 16
  • 27
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
  • 643
  • 6
  • 22
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
  • 3
  • 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
  • 815
  • 6
  • 13
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
  • 330
  • 3
  • 14
1 2 3
…
17
18