How to merge DB of different branches of the restaurant

Tags:

Hi I have 2 branches of the restaurant, each of them using a sambapos implementation. There is a way to merge these 2 Databases in order to make consolidate reports.

thanks

4 answers

emreeren

Nov 13, 2013

Reputation: 595

There is no database merge feature on SambaPOS side. SQL Server has "Replication" feature for such operations. It may help.

edominguez

Nov 13, 2013

Reputation: 17

Hi Emre, thanks for the answer and thanks for the great system Sambapos.

Regards,

Syed

Nov 22, 2013

Reputation: 23

You could use centralised database for both Restaurant..

Thanks

Syed

Hi Syed, sorry for my ignorance, but how can I do this if they are fisically in different places? do I need public IP and expose my server to the web?

thanks,

regards,

edwin

edominguez on Nov 22, 2013

Syed

Nov 23, 2013

Reputation: 23

No worries, Samba Developers have done a great job and Samba can be used various ways. I am also new to samba but I do have background in SQL and .NET, I do belive it can be done easily

In my mind there was two possible ways, both requiring remote db access:-

1) you can buy database space on remote server and host you db there and use SAMBA client on all pc in both resturants, all PC acces database hosted remotly.

2) 2nd option in my mind was to use replication, may be transactional replication or replicate local db once in 24 hours to remote server db.

Obiously whatever is not part of samba out of box will be modification to fit your business model but it can be done.

Hope this helps

Regards

syed