I'm looking at synchronize methods between two databases and found Microsoft Sync Framework recently. I've been trying to investigate if it suits my needs.
My scenario is the following:
Two SQL-databases located in different geographical parts. The remote database can go without internet connection for days at times and for some locations the only means of communicating is with ftp transfers to the main server.
So my question is: Is it possible to sync between two servers and send the sync-information and data through a ftp-server?