I have c# desktop application with MS-Sql server as back end. This desktop application will be running in two different systems (database will also be in local system), I want the data to be synced between these two systems bidirectionally.
For this I am able to generate JSON file for the differential data, now I want that JSON file to be transferred to the other system. On receiving JSON file, I can update and insert data to the database.
I am using .Net 4.0 and MS Sql 2008.
Please suggest me, how can I pass the JSON file from one system to the other system.