Database Sync

Hi, it is doable , since all the clients have their own database, so the cloud server will have all the databases of the clients. I don't understand why you need the bidicetional which would be Relevant Skills and Experience useful in case of the clients would connected on the cloud, if this is not happening then you can have one direction, from client to the cloud. Very important all the tables must have Primary Keys. Proposed Milestones $100 USD - at the begin which must be also released. $400 USD - at 50% $200 USD - at 80% $300 USD - at 100% How big are the databases , i will need access to all the client's DB and on the cloud too.

There are a lot of ways to do bi-directional sync 1. SQL Replication. it is built-in technology in SQL Server. But looks like it does not applied to your situation with long time without sync. Also it require as I remember SQL Enterprise version. 2. Azure SQL Data Sync. It's technology from Microsoft Azure to sync with on-premise SQL Servers. Will require host in Azure SQL. If something not changed, data must be synced at least every 5 minutes. 3. Custom written sync. Custom written app of course will flexible solve your needs, but will cost more than already done technologies. I have experience in all above areas. So you need to provide your requirements to estimate which one method applies to your situation.

I have master degree in computer science, specializatiin- database systems. my suggestion is to have properly planned and configured replication.

Hi, this is not the right approach, you dont need full fledged individual sql server at client machine, you can have a small versionlike sql express, sqlite etc, you need an application\task for sync Relevant Skills and Experience I have worked in POS application, check my linkedin Expert in Asp.net MvC, VB.net, c#, SQL server, Web Api, WCF, WPF, Xamarin, JQuery,EXTJS, Angular Js, bootstrap,azure,AWS. Proposed Milestones $100 USD - requirement analysis $255 USD - design analysis $200 USD - documentation and coding if any

Dear sir I'm very interested in your project I have been working in IT part for last 6 years Relevant Skills and Experience As it was known,I'm expert of this part I'll help you in all IT part I'll wait for your good news Good regards Proposed Milestones $1111 USD - I'll help you

As I have checked the approach is correct. You need different instances locally in case you want to work offline as well. Relevant Skills and Experience I am working as MS SQL server admin with HCL Technologies. Please contact for further discussion. Proposed Milestones $722 USD - Installation of SQL server on each server and creation of instances. We need to discuss things in detail and work on it. Contact me for further discussion.

Recently I have implemented this type of solution using Sql Azure as a Main server, each client will synch with bidirectional. I have good experience on it. Please ping me