I need to create a new dialect for SymmetricDS to replicate data from MySQl/MSSql/Oracle to new database(there is no dialect for it now). This database has specific sql. I have read http://www.symmetricds.org/developer/how-to/implement-symmetricds-database-dialect but still don't understand what start with.
Can somebody explain how to create new dialect for SymmetricDS. Also I want to modify some data(maybe transform) while I replicate it from current database to my new one. Thanks!
Check the issue tracker if there's a plan for implementing the missing dialect. If there's no plan fork the project on github. After checking out the code observe the implementation of supported dialects by searching for classes having 'oracle', 'mysql' or 'postgres' in their names. Choose the dialect closest to the one missing, copy the classes and modify to meet the needs.