Open source database replication software.
Questions tagged [symmetric-ds]
7 questions
4
votes
1 answer
SymmetricDS Setup - SQL Server 2008 to MySQL
I need to replicate just a couple of tables from a Microsoft SQL Server 2008 database to a MySQL 5.7 database (one-way only). I've been struggling to find a simple solution.
I've ultimately decided to try SymmetricDS, but the setup is confusing:…
Ryan
- 41
- 3
2
votes
0 answers
symmetricds 3 tiers one way registration problem
i am trying to setup a one way 3 tiers replication using symmetricds like so
the company, intermediate, web servers have respectively these ip addresses
192.168.173.1 /
192.168.173.15 /
192.168.173.16
the engines folder in the intermediate server…
user2475096
- 145
- 5
2
votes
0 answers
SymmetricDS scheduled sync
I am trying to configure SymmetricDS to run a scheduled replication from one postgres database to another.
I've seen people suggesting doing that by setting these fields in node config:…
mix
- 21
- 1
1
vote
0 answers
Issue replicating updates to primary key data with SymmetricDS
I am replicating from MSSQL (SQL Server 13) to PostgreSQL (9.5) using SymmetricDS.
The table that is replicating has a composite key of 7 different columns. Everything works perfect from an initial load to inserting and updating data.
However, I run…
Andrew B
- 23
- 3
0
votes
0 answers
SymmetricDS time-based sync
I'm trying to configure time-based sync on SymmetricDS, currently I'm using trigger based sync for PostgreSQL to Oracle, but since it's overflowing the database on insert, updates there's another possible option to run sync using additional column…
Mendbayar Alzakhgui
- 11
- 3
0
votes
1 answer
UTF8mb4 MariaDB 10.4 - Max key length is 767 bytes error
I am running MariaDB 10.4.
I am trying to setup symmetricDS for database syncing. Some of the tables it creates have fields that are are VARCHAR(255). I know UTF8mb4 can only support up to VARCHAR(191)
I know I can setup my database to be UTF8 and…
Matt Winer
- 395
- 1
- 3
- 7
0
votes
2 answers
SQL Server - TIMESTAMP caused exception
I am syncing from PostgreSql to MSSQL using SymmetricDS. Some tables of the source database have timestamp field set too '0001-01-01 00:00:00.0' and it could not be able to insert to destination(SQL Server) database.
Is there anyway to work around…
