Hello 'professional' Java programmers - this is my third try to develop a solution that can synchronize data from a MySQL Server and an Sybase ASA 11. I need a solution that can handle parts of tables and the replication beetween fields with different filenames. Bi-directional replication is needed. JAVA is recommended. For further projects the solution should work with other databases(e.g MSSQL) too. Give examples for your work you have done and if there are related, please.
good tool for this could be:
or programming an own solution, but i need it open source at the end
All ideas are welcome!
Here my idea, that 2 developer could not finish:
1. I look after an expert who can Support(via ssh/remote) and describe(easy docu) the Installation of SymmetricDS GPL(http://www.symmetricds.org/) on a LINUX NAS Server(MySQL) with one Windows Client(Sybase).
2. implementing Sybase Anywhere Support to SymmetricsDS
3. Setup the bidirectional replication between a Client Windows 7 with a Sybase Anywhere 11 Database and the LINUX Server MySQL.
I need a Service that can replicate a Sybase Anywhere Database with an match/filter table to MySQL, but this in both directions. Thats the reason I want to use SymmetricsDS.
The job is - setup the both systems, implementing code if something is missing and write a documentation that I can handle this next time alone. Can you do this? With all used adjustments for both databases? Then please give references an feel free to make an offer. Better ideas are welcome, but I need the source and a complete solution. I need a system for future and further developing next time.
Main-content of the Project:
some tables should be in replication after this job(with using the matchtable) and an installation docu has been finished. The projectfiles should be handled as a GIT fork from original SymmetricsDS System via bitbucket.org.