Data sync between two desktop applications

Question

0.00/5 (No votes)

See more:

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.

What I have tried:

Using node js , i created API to post the json data to cloud data base and api to download the json data. But I am not sure whether this is the right approach for this requirement.

Posted 12-Jul-23 1:44am

Member 9929607

Updated 12-Jul-23 22:02pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-07-12T03:30:00

Solution 1

If the systems are both on the same LAN or WiFi network, then Sockets in .NET - .NET | Microsoft Learn[^] is probably a good place to start.

Posted 12-Jul-23 3:30am

OriginalGriff

Graeme_Grant · Answer 2 · 2023-07-12T22:02:00

Solution 2

Expanding on @OriginalGriff, you could use SignalR (Microsoft Learn)[^] for realtime updates. This would remove the need to be on the same local network and is a managed with typed support.

Posted 12-Jul-23 22:02pm

Graeme_Grant