CODEWITHSUNDEEP
c#wcfclient-serverdesktop-application
Akrem
Akrem

Reputation: 4652

From simple desktop application to client server application

I have developed a simple desktop application with a SQL Server database for a single PC and now the client want to make it work on multiple PCs. I want to know what is better: for the moment I have remote the database from sql management and all application just connect to it. Is this a good idea or do I have to do some modification to improve the executing of the application?

Upvotes: 0

Views: 2293

Answers (2)

FIre Panda
FIre Panda

Reputation: 6637

You could have a dedicated server with database hosted on it and all the client applications could connect to it. But one thing you have to take care of is transaction management that is while a user is updating some piece of information, no other user could change that piece of data to make that data inconsistent. You could a look at this post describiing Sql Server Transactions.

Upvotes: 2

dain
dain

Reputation: 6689

Depending on the requirements I'd recommend keeping the local database as cache for speedy application start and implement a synchronisation process where the local and remote databases are compared from time to time or triggered manually by the user.

This would be very similar to how for example IMAP email clients or Evernote works.

Upvotes: 0

Related Questions