I need to monitor Sync gateway changes and push any appointments booked etc back to the primary SQL database (also on Azure). From a service on Azure I will be able to access both CB and the SQL database, so given a changed doc I can extract the data and update SQL db.
I’m proposing Couchbase for a new project. We need to sync data between multiple mobile devices via P2P during the day and sync changes back to an existing SQL database when connectivity allows.
My current proposed solution is a small Couchbase server running on Azure. This will be refreshed nightly extracting only the data required for the following days activities from the existing SQL database. Users will sync mobile devices to CB server prior to setting off in the morning. P2P will keep the mobile devices sync’d during the day (appointment booking, customer details updated etc), with one device as a nominated server (Android NSD to advertise the service and remaining devices to discover and sync to nominated server device).
When connectivity is available (it may be constant, it may be patchy) the nominated server device will sync to the Sync Gateway on Azure.
What would be the suggested way to implement a change event handler on Azure (We currently have an .NET MVC WebApi running on there which could be extended). We are primarily .Net/Android devs.
Does this sound like a sensible use of CB. If successful I’d like to extend the data stored in CB in the future and possibly migrate away from SQL.