Can the Microsoft Sync framework for ado.net work with Java?
I am planning to use the following architecture for one of the applications: Client: Java based application that will use the MySQL database Server: will be in C # and the database will be SQL Server
Can you use Microsoft Sync Framework in Java now? (Perhaps by implementing some interfaces?). I want data from Java client to sync with server and vice versa. Is it possible?
If not, you can suggest a different sync structure.
source to share
Firstly, I'm not familiar with Sync, but a quick look at the overview suggests that your client will need to provide either a web service or an RSS feed so that the Sync runtime can receive data that needs to be synchronized with the Java process.
The problems I see with your design is that there are usually multiple clients in this case, but semantically one backend is the MySQL database in this case. I suspect this will lead to synchronous thinking when multiple clients are in conflict, but I could be wrong.
Anyway, I suppose your goal is to keep MySQL and MSSQL databases in Sync? If so, why not start a server process in front of the MySQL database, which will become a synchronization participant. If you have alread.Net on the server side, you can even write it in C #, which will surely ease interoperability problems.
If you are set up on a client that is a member of Sync take a look at Jakarta Commons which I think has the code you need to turn your client into a simple web server that will need to act as a web service or RSS channel.
source to share
You will need to find the "glue" between Java and the Sync base. Java Native Interface will get you off to a good start.
source to share
In fact, you can use change tracking directly from the SQL server.
http://msdn.microsoft.com/en-us/library/cc280462(SQL.100).aspx
source to share
You can have a "client" portion of the Sync Framework — a standalone C # .NET application or service. This means deploying the sync client and the .NET framework to client computers. You will also need to create a MySQL client client for the Sync Framework (although you can probably find or adapt something from the code).
If you cannot install .NET on client computers, you may need to use the synchronization system built on the Java stack and use it. Something like one of the solutions suggested here: Open Source Framework and Microsoft Sync Framework Suggestions? ... At least some of the suggestions can speak to both MSSQL and MySQL.
source to share