Can I sync My Windows Application and My Web Application?

Question

1.00/5 (1 vote)

See more:

Good Day, Please can some one help me out here!
I have a windows application and a web application with same database structure, Is it possible for my windows application to synchronize with my web application so that when ever i am connected to the internet, I will be able to download all the data on the remote server to my local machine, for the windows application....A very good example of what i am talking about is Microsoft Outlook..
My Application is on visual studio 10 and C#..

thanks and i do appreciate your lovely time..

thanks

Posted 6-Aug-13 1:03am

Difameg Network Nigeria

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)

onelopez · Answer 1 · 2013-08-06T01:37:00

If both applications are online all the time, then you could simply use the same connection string to the database. The problem will arise when your Windows application is unable to get online...

Your solution can either be letting the user know this Win application only works online, or have a separate embedded db with the same structure as your online db and download/upload the new content whenever it gets online.

Outlook achieves this through timestamps, emails have timestamps, so it's easy to know "Yes, this is a new email" so outlook goes ahead and downloads everything from the latest timestamp it knows.

RelicV · Answer 2 · 2013-08-06T01:59:00

Hi Difameg...,

I've had a similar issue previously in my project where we had 2 applications. One is a Web app and the other is a Windows app. Both of them use a same DB. Till that point, everything was fine. But later on, my client said that the Windows app would not be connecting to DB while at remote locations. Then, we looked into a concept called Synchronization of Database. This concept runs like this:

1. Web application will always work on MasterDB.
2. Windows application will work on PeerDB (same schema as MasterDB).
3. Initially, we synchronize both the MasterDb and PeerDB to make sure that they have same lookup data for login purpose, other static data, etc.
4. Now, Windows application would work on its own PeerDB for as long as they want to.
5. To get the data back into MasterDB, they would synchronize both the databases.

Now, you'll have all the data into MasterDB, as well as PeerDB for offline working.

Please do look into Microsoft Synchronization Framework 2.0v. This would solve most of your problems.

Thank you,
RelicV

Can I sync My Windows Application and My Web Application?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0