When comparing gitSQL vs SymmetricDS, the Slant community recommends gitSQL for most people. In the question“What are the best relational database migration tools?” gitSQL is ranked 8th while SymmetricDS is ranked 10th.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Direct reading Oracle dump files, can either create new table(s) or merge into existing
Pro Migrate data
Can script out data too.
Pro File systems
Can also duplicate entire file systems.
Pro Multi database
Support for Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2 (UDB, iSeries, and zSeries), H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite, Sybase ASE, Sybase ASA (SQL Anywhere), Amazon Redshift, MongoDB, and VoltDB.
Cons
Con No update scripts
Does not seem to provide update scripts, only create scripts for the full database and data.
When you have an existing production database, you do not want to re-create the database.
Con Installs triggers
SymmetricDS does install database triggers.
Con Limited free version
The free version does not have a GUI and can only be used from the command line, see comparison.
There is an open source GUI dashboard available however: DRD Replicator.