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

SymmetricDS Pro trial version on Ubuntu

How can I install SymmetricDS Pro trial version on Ubuntu? I have already tried to copy the web directory of the pro version into the directory of the community version. But some errors occur.
nzeacha
  • 1
  • 1
0
votes
1 answer

Retrieve requesting node's external id inside INodePasswordFilter a SymmetricDS 3.5.x extension point

I have a retail system where the central node is corp-0 and store node is store-1, store-2, etc. I am using SymmetricDS 3.5.13 to do sync between a store node and a corp node. I have to authenticate every store node that tries to connect the corp…
0
votes
2 answers

Bulk initial load for postgresql in SymmetricDS

I trying use symmetricds to configure mysql to postgres synchronisation with transformations. I have very low inserting performance on initial load with 100% CPU load by postgres. When I look to postgres log I found that it used INSERT. It's ok for…
tbicr
  • 24,790
  • 12
  • 81
  • 106
0
votes
1 answer

SymmetricDS: real time synchronisation of MySQL with PostgreSQL

I need to move a huge system from MySQL to PostgreSQL. This cannot be done in one go, which is why I need a robust (real time or near real time) data bi-directional synchronisation solution between MySQL and PostgreSQL. SymmetricDS looks like a tool…
Caballero
  • 11,546
  • 22
  • 103
  • 163
0
votes
1 answer

SymmetricDS Embedded

I'm trying to implement database synchronization using SymmetricDS. So far I am able sync database using standalone client and server. Now I want to run SymmetricDS from java code: SymmetricWebServer node = new…
user2275785
  • 199
  • 1
  • 19
0
votes
1 answer

synchronizing with source node id

I would like to know how to do a sync through source_node_id through columms transforms. X The table will update a record in table y, and I want it to update the record that it is (identified by source_node_id) id | name | source_node_id 1 | a |…
juniorb2s
  • 242
  • 4
  • 11
0
votes
1 answer

Error in symmetricds client set up

Unable to set up client which is derby and server is mysql C:\symmetric-ds-3.0.1-server\symmetric-ds-3.0.1\samples>..\bin\dbimport --engine client1 --format XML create_sample.xml Log output will be written to ../logs/symmetric.log [] -…
smitabk
  • 9
  • 2
-1
votes
1 answer

Symmetric DS different PK but same unique resolution

We have this MySQL table: id BINARY PRIMARY KEY, -- this is actually GUID position INT NOT NULL UNIQUE some_value VARCHAR(200) On each of two nodes, users create a new entry but with the same position: id=0x01 position=5 some_value = "first node…
-1
votes
1 answer

SymmetricDS Tables not syncing

I took over a project that uses SymmetricDs to sync tables between a target and a source. The tables from the source aren't syncing to the target at the moment. I have searched online but found no help. I have checked the sym_outgoing_batch and…
Dikum
  • 31
  • 3
-1
votes
1 answer

SymmetricDS File Synchronization on android

I'm using symmetricDS for sync my app db(sqlite) and server database(SQLServer) and i try syncing files between my app and server but after create file in target directory in server side, new record create on outgoing batch by "New" status and never…
-1
votes
1 answer

symmetricds SYSADMIN send-script error

the command of sending a sql script to node or node group is working fine but the issue is with parsing the file itself. Here you are, the log of the target node 2014-08-27 16:51:12,130 ERROR [station-001] [DataLoaderService]…
1 2 3
19
20