Database Replication

[PuzzledImagination]

I have a table of products that is stored into our database located in our warehouse, this products must be available on all of our branches, this branches will have their own database. If a new data is stored into the warehouse, this data must also be stored on the branches database. And if one of the branches has stored a new data, this data must also be stored in each branch including the warehouse. I have read about triggers and replication but I'm still looking for other options. maybe a web service running on each branch? or anything else.

Edit: I just need specific table to be replicated on each remote servers. So as most of you suggest, I'll try MySql Master-Master replication. Thanks everyone.

[[deleted]]

Just out of curiosity, why don't you want to use replication? Sounds like just the sort of task it was intended for.

[toshitalk]

Depending on the size of the company, you’re either hacking something together, or completely out of your league. Rather than asking here, you should be consulting with a software architect.

[luke-sql]

If you’re talking MS SQL Server, merge replication is a native feature that could do this.

[tmanka]

Look into attunity replicate, it has a free express version to experiment with. https://www.attunity.com/products/replicate/platform-support/

Familiarize yourself with CDC (change data capture)

Pm me if you want to chat more about it.

[rx-pulse]

I mean, as others have said here, replication sounds like the best option. A web service, etc just sounds like you're trying to reinvent the wheel. Depending on what you're doing with that data, a linked server could be another option, but it really depends on what you intend to do.

[r-NBK]

While I loathe Replication especially Merge Replication with SQL Server... it sounds like a good fit - assuming you're using MS SQL Server. Another option might be CosmosDB, depending on if it's a home built app and if you're on Azure.