From simple desktop application to client server application

I have developed a simple desktop application with a SQL S开发者_运维百科erver 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?

• The database has a lot of information to be imported to the application.

• I don’t have a good idea about WCF but would it help to read about it?

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.

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.