I am developing Point of sales software, which have multiple branches and one main branch. Main branch is web based while all other branches (9 now, which may exceed) are desktop based. Client required that all branches must sync main branch whenever internet connectivity is available. So my question is that which sync functionality should i use? I have not much idea about syncing as never work before on syncing. Some of basic requirements are as follow: Main branch can purchase or sell any item for any branch and stock + accounts will be hit. Other branches can purchase and sale for them not for other branches but they can see other branches stock, their customers and accounts. Remote branch can move stock to any branch. These are some basic requirements which may change according to clients wish. So kindly guide me how can i sync complete data bases. Should i use my own logic or some builtin functions. Thanks
1 Answer
Merge replication (link) might be a suitable solution for synchronising your data. Controlling the access so that your branches can only edit certain parts of the data should be controlled within your application.
-
Thanks HandyD I will try to implement this and if this works. Commented Dec 20, 2018 at 4:50
-
I have followed tutorial and i have successfully applied merge replication on my local system by making multiple instances of SQL Server. Now issue is that when i am applying same thing for my live server i have successfully configured live sql server for publication, and when i am creating subscription on my local server and for that when i am finding sql server for publisher its giving error that "SQL SERVER REPLICATION REQUIRES THE ACTUAL SERVER NAME" Can any one help me. I have searched alot and tried alot of solutions but failed Screen shots attached Commented Feb 1, 2019 at 15:44
-
-
-
Take a look at this link: blog.sqlauthority.com/2015/09/18/…– HandyDCommented Feb 3, 2019 at 21:19