How to Sync values from one DB to another DB?

Sep 29 2016 6:52 AM

I have a query. See the bellow diagram, I have 3 different databases located on different server / cities.

1. If client inserts (update/delete) some values in their database then that values should also reflect (insert / update / delete) in other databases as well.

2. If on local database if suppose developer inserts some values then same thing should be happen in other databases.

Please suggest me some solutions for above problem.

Is their any need to do a any application for this ?

Can I use triggers for this ?

Thanks

Answers (2)

When Generating scripts , do we need to run all the code?

getting error of <